Count locks per session by resource and mode, connect open transactions, and recognize escalation while keeping snapshot limits clear.
SQL SERVER Management Studio – Completion Time in Messages
When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.
Tables Containing a Column: Search by Name in SQL Server
To find tables containing a column, search sys.columns by name instead of opening tables one by one. This post searches one database, then every database on the server, and shows why an underscore in the pattern needs brackets. It also compares the data types of related columns.
How to Use Multiple Hints Together for a Query? – Interview Question of the Week #241
Question: How to Use Multiple Hints Together for a Query?
Answer: Of course, you can use multiple hints for a query. Here is an example of the same.
SQL SERVER – Active Parallel Requests and Cached Parallel Query History
I Identify parallel running requests separately from parallel queries recorded in the cache. Those lists answer different performance questions.
Listing Driver, Encryption and Auth Scheme for Every Connection
Inspect the auth scheme, encryption, driver interface, and protocol for current SQL Server connections, then group the results clearly.
Do Stream Aggregate Operator Always Need Sort Operator? – Interview Question of the Week #240
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.