How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
2010-07-14
27,379 reads
Stephen Hirsch
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
2006-09-19
5,684 reads
What is XML?
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
2006-07-24
10,951 reads
Blogs
Logical crossroads in Azure Data Factory (IF and Filter operations)
By Rayis Imayev
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
Forums
Trying to get output of PRINT command after select in Transaction
Hi I am looking to select the output of the data that I plan...
Use Domain Account for SQL Server service on Linux
Currently, while installing SQL server we use a local linux account to run the...
Ask SSC