Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
12,968 reads
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
12,968 reads
Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.
2002-02-27
12,862 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,376 reads
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
2002-02-12
14,828 reads
By Steve Jones
As we close out the year, I decided to drop this post here and...
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Hello, I currently have an instance of SQL Server 2019 Developer installed on my...
Comments posted to this topic are about the item How to Attach and Detach...
Comments posted to this topic are about the item What is Terraform?
What is Terraform (from Hashicorp) used for in technology?
See possible answers