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
13,103 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
13,103 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,910 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,383 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,843 reads
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...
One of the new features in Kubernetes v1.33 is the ability to resize CPU...
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
When comparing AWS RDS and DynamoDB, the core difference lies in structure and use...
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Comments posted to this topic are about the item Creating a new API in...
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers