White papers, DMVs and Monitoring Concepts
According to Jason Strate (SQL Server MVP) there are 5 white papers ever SQL Server DBA should read. Considering my...
2013-06-01
1,011 reads
Simple SQL Server
Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
674 reads
Wait Stats – Monitoring and Using
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...
2013-05-21
1,833 reads
Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,448 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,718 reads
Job Schedules – SQL Agent
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,310 reads
Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,013 reads
Table Sizes
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
648 reads
Index Columns and Names
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,415 reads
Running Processes
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
853 reads
Blogs
Starting Points for Quantum Computing Learning
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
SSMS 21 Fixes Irritating Problem
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today,...
Monday Monitor Tips: Customizing Data Retention
By Steve Jones
One of the biggest challenges with monitoring data is managing the volume over time....
Forums
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
Window Functions in a View
Is there a trick to get a where clause filter to push into a...
Modifying the fetch size for Linked Server
Hi, Problem: Pulling several million row table from Oracle DB into SQL server via...
Question of the Day
Adding Lots of Dates
The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?
DECLARE @d DATE = GETDATE() SELECT EOMONTH(@d, 95695)See possible answers