Performance Tuning Using Free Tools
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2021-12-17
5,390 reads
database performance
A simple use case for Columnstore Indexes in SQL Server
In this article we look at different use cases for columnstore indexes like when performing SQL Server count * queries.
2020-01-17
2019-10-28
5,976 reads
Blogs
Slides from SQL Saturday Los Angeles 2022
By Steve Jones
If you attended my talk at SQL Saturday Los Angeles 2022, then you can...
Creating a HEAD utility for Windows 10
By Steve Jones
One of the things I did often in my first career job was create...
Distributed Replay: The Little Engine That Almost Could
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...
Forums
SELECT * FROM ( ... ) X
Hi all! I'm trying to understand how does this work. I've read a thread...
Would like to understand a better way of updating data that a cursor if possible
I have a need to update some data and also create a record of...
SQL Question - Column References
Hi. Looking for someone to help with a query I'm tring to run. I...
Ask SSC