The Case of the NULL Query_Plan
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,245 reads
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,245 reads
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,353 reads
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,275 reads
UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!
In my recent adventures...
2013-07-23
1,623 reads
Before we get started, I want to make it clear this is NOT how you would normally configure all these...
2013-07-16
2,410 reads
Industry experts will tell you that virtualization of your environment is not done to improve performance, it's done to make...
2013-06-25
4,262 reads
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,130 reads
Sometimes rapid code development doesn't always produce the most efficient code. Take the age old line of code SELECT COUNT(*)...
2013-05-07
5,267 reads
With opening day of Major League Baseball season finally here, I thought I’d take the time to cover two of...
2013-04-02
1,263 reads
Database mirroring has been around since SQL Server 2005, and it's turned out to be an excellent step up from...
2013-03-26
2,434 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