I like to use the keyboard whenever I can in SQL Server Management Studio. It’s not always easy to remember every shortcut though– especially when those shortcuts change!
Since around the SQL Server 2012 era, you’ve been able to switch Intellisense on or off on SSMS with the shortcut chord: CTRL + Q, CTRL + I. I remembered this as “Control Quacky Intellisense.”
A user recently asked me what a good use case might be to run SQL Server on Linux in a Docker container.
One cool little feature in SQL Server 2016 is COMPRESS(). It’s a TSQL function available in all editions that shrinks down data using the GZIP algorithm (documentation).
It can be tricky to remember that SQL Server doesn’t short circuit on IF statements in stored procedures. Even when you know this, sometimes it’s hard to recognize the impacts.
Microsoft recently gave us a more lightweight way to trace data related to execution plan performance. As of SQL Server 2014 SP2, you can trace the query_thread_profile Extended Event.
They say, “never read the comments” on the internet, but I’m lucky to get lots of interesting points and questions in my comments.
SQL Server has more than one way to pull pages in from disk for your queries. SQL Server can do a physical read of an 8KB page, or an extent of 8 of those 8KB pages.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.