Friday, December 20, 2024

Query for getting a quick overview of both index usage and structure, at the same time

›
 In tuning up some indexes, I was always switching back and forth between different screens and resultsets. There's two main sets of inf...
Monday, July 31, 2023

Which objects are using those barely used indexes, that you want to get rid of?

›
Indexes in SQL Server are obviously critical, but easy to overuse - to the point that the indexes themselves cause problems. For instance, y...
Thursday, June 8, 2023

Clustered indexes—how to make the right decisions

›
Oftentimes, with database systems, nobody is specifically in charge of the database. It's just seen as one of the many tools that's ...
Sunday, February 5, 2023

Help! The field I need to query isn't indexed, and I can't change that!

›
Some things you can change, and some you can't, right? And for whatever reason, you may need to query a huge table, and not be able to i...
Monday, November 14, 2022

Improved and updated, round 2: performance tuning a stored procedure with user defined function calls in SQL Server

›
Recently I was reviewing performance on a troublesome stored procedure. I used the method detailed in my recent blog post:  UPDATED! Perform...
Tuesday, July 26, 2022

The magic of Query Store for tracking application timeouts

›
If I were writing a click-baity title for an article on this, it would be "One Crazy Trick To Find Application Timeouts That Will Blow ...
Tuesday, May 17, 2022

Why is my transaction log growing?

›
I advise on the management of multiple large databases. One of them had a steadily growing transaction log.  Figuring out exactly why the lo...