Query Tuning 101: Debugging a procedure
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,375 reads
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,375 reads
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
700 reads
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,107 reads
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,696 reads
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
961 reads
I wanted to take a quick moment to thank Denny Cherry for selecting me for Speaker Idol this year.
For...
2016-10-29
761 reads
I’ve been testing the new Temporal Tables feature over the past day to see about using it in one of...
2016-10-26 (first published: 2016-10-17)
2,808 reads
Long ago there were locking / blocking problems with the SELECT INTO statement. That’s not the case anymore and for AdHoc...
2016-10-20
1,045 reads
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,811 reads
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,156 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers