Start auditing query hints in modules and Query Store, rank the busiest statements, and test removal with measured plans and rollback.
SQL SERVER – List Expensive Queries – Updated March 2021
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.
Case-Sensitive Search – SQL in Sixty Seconds #158
Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.
SQL SERVER – Case-Sensitive Search
How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
SQL SERVER – Data and Index Compression – Real-World Conversation
Today we are going to see a real-world conversation about Data and Index Compression in SQL Server. I recently discussed this with my client.
Memory-Optimized Tables as a Key-Value Cache
Build a key-value cache with SCHEMA_ONLY memory-optimized tables, native get and set procedures, expiry checks, and bounded cleanup.
SQL SERVER – Top 3 Wait Stats from Real-World
It took me more than 9 hours to respond back every single email, I had received on this topic. Here are the Top 3 Wait Stats from Real-World.