Query Store status for every database takes two queries, and the first is not enough. This post builds four demo databases, shows why the is_query_store_on flag hides frozen and read-only states, and runs one script that reads the real state of each database. It also shows what Query Store costs in memory.
SSMS Command Timeout: What the Execution Time-out Does
The SSMS command timeout is the number of seconds a query window waits before it cancels a batch. This post lists the four places a time-out can come from and reproduces a client time-out with sqlcmd and PowerShell. It also shows how an Extended Events session proves that the client gave up.
SSMS ROWCOUNT Setting: Why Your Query Stops at 100 Rows
The SSMS ROWCOUNT setting limits every query in a window to a fixed number of rows, and it can change the plan as well. This post shows the effect on rows, reads and plan with a tested demo, how to check your own session and why UPDATE statements stop at the limit too.
sp_helpdb in SQL Server: List Databases and Their Files
sp_helpdb in SQL Server lists every database on an instance, or the files of one database, with a single call. This post builds three small databases, reads the output column by column and explains why db_size is text. It also shows how to filter the result and how to find free space.
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.
How to Import a SQL Server Table Inside Excel Sheet? – Interview Question of the Week #273
Question: How to Import a SQL Server Table Inside Excel Sheet?
Answer: Well, the answer to this question is pretty straight forward and let us see it today.
SQL Terms vs MongoDB Terms: A Practical Glossary
SQL terms vs MongoDB terms trip up teams that use both products. This glossary maps tables, collections, rows, documents and fields, shows tested SQL Server queries beside the mongosh equivalents, and marks where the vocabulary stops matching.
Forcing a Plan in Query Store and Checking That It Held
Use forcing a plan in Query Store with verified IDs, then audit force failures and runtime results every week so the fix stays useful.
Duplicate Statistics: Auto-Created Stats That Shadow Index Statistics
Find duplicate statistics on index-leading columns, compare freshness and sampling, and generate cautious DROP STATISTICS candidates.
SQL SERVER – Scrollbar in the Middle – Bugs Fixed by SSMS Team
SSMS 18.5 fixed the Database Properties scrollbar that opened in the middle. Read the funny true story, see the original evidence, and enjoy the fix.