A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.
Finding Sleeping Sessions That Still Hold Locks
Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.
SQL SERVER – List Schema Name and Table Name for Database
A quick query on sys.tables with SCHEMA_NAME() that lists the schema name and table name of every table in a database, in bracketed form.
SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors
Today I write my 1000th article on this blog, with 8 million views so far. Thank you to every reader who made this long journey so rewarding.
SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
What does the query optimizer hint ROBUST PLAN do? I explain query hints in simple words and ask you for a practical example of ROBUST PLAN in action.
SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.