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,140 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,140 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
13,067 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,424 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,893 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers