Use Dynamic SQL to Improve Query Performance
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
30,329 reads
This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.
2012-02-17 (first published: 2010-05-20)
30,329 reads
How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.
2010-06-21
9,811 reads
This shows a method for generating scripts for SQL Server stored procedures and functions so they can be added to a version control management system (VCMS).
2010-05-06
19,650 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers