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,436 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,744 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,989 reads
Blogs
Daily Coping 3 Oct 2022
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
Scary Scalar Functions - Part Four: Your Environment
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Being a script magpie
Last month (I ran just a little bit late writing this, it was meant...
Forums
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue.
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Referencing a SQLCMD variable in a Post Deployment script using SqlPackage
Ive got a Database project running in JetBrains Rider. The project publishes a DACPAC...
Ask SSC