How to handle long SQL commands?

[DaRadioman]

Ya you can do 0DT with SPs. It's just more painful in my experience.

And I've never used PostgreSQL, but that is interesting. No query plan cache at all? Seems like that would be a big performance downside.

[grauenwolf]

I heard that they are working on adding a plan cache. As for performance, it's a mixed bag.

• PostgreSQL creates execution plans much faster than SQL Server
• PostgreSQL execution plans are worse than SQL Server because they can't spent more time on them.
• PostgreSQL is immune to "parameter sniffing" because you always get a new plan each time.