Finding the names of all indexes on a SQL Server
I needed a way to list the indexes for an entire database, but I was running into a problem using sys.indexes that I could only… Read More »Finding the names of all indexes on a SQL Server
May 2021
CTE Query Performance
The following question came up when working on my CTE presentation for SQL Saturday. Does a query that JOINs a CTE to itself execute the… Read More »CTE Query Performance
April Blog Post Wrap-up
by Steve Stedman and the Stedman Solutions Team Optimize For Ad-Hoc Workloads – Video Tip Tue, 27 Apr 2021 Learn how Optimize For Ad-Hoc Workloads… Read More »April Blog Post Wrap-up
Questions Following Corruption Presentation – Video
These are 5 questions asked after our February 2020 corruption presentation. Hope these answers help you as well. Transcription: 0:10Q: So our very first question… Read More »Questions Following Corruption Presentation – Video
Index Seek vs Index Scan
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it really… Read More »Index Seek vs Index Scan
- « Previous
- 1
- 2