This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server.
2002-03-14
11,374 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,792 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,735 reads
In this article by Robert Marda, he shows you how to detect and correct deadlocks.
2002-02-19
8,366 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,760 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers