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.
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.
Rebuild All Indexes on a Table in SQL Server: SSMS and T-SQL
To rebuild all indexes on a table, right-click the Indexes folder in SSMS and choose Rebuild All, or run ALTER INDEX ALL with REBUILD. This post checks fragmentation first, rebuilds a demo table and shows what the command does to a disabled index. It also compares REBUILD with REORGANIZE and the options that matter.
Canceled Query Plan: Three Ways to Capture It in SQL Server
A canceled query plan can be captured with Live Query Statistics, with a live plan query while the statement runs, or from Query Store after the cancel. This post runs a long query, reads its plan while it runs, cancels it and then reads the aborted run from Query Store. It also explains which plan each method returns.
How to Check Database Performance Facets in SQL Server? – Interview Question of the Week #270
Question: How to Check Database Performance Facets in SQL Server?
It is very simple to find out the facets of SQL Server Just follow the diagrams listed.
Capturing the SQL Behind SSMS Reports With Extended Events
Capture the SQL behind SSMS reports with a filtered Extended Events ring buffer, inspect batch text, and remove the session afterward.