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,402 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,690 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
How SQL Server stores data types: DATETIMEOFFSET
If you’d like to check out the previous instalment in this series on storing...
Daily Coping 16 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Server Review Essentials for Accidental and Junior DBAs—Prepping for Server Reviews
By Kevin3NF
Welcome back to our series, Server Review Essentials for Accidental and Junior DBAs, where...
Forums
deadlock prevention
Hi All, I' m looking for some help in interpreting and fixing the deadlock....
Forum bug with the "like" button
I was looking at a post, specifically this one: Performance Counters Missing in SQL...
What's the difference with installs for Core vs Server/Cal?
Does anyone know why under MS vol licensing there are SQL 2019 Std installs...
Ask SSC