How to find blocking in SQL Server in under a minute: the DMV queries that show who is waiting and who the head blocker is, what to do right now, and how to stop blocking from coming back.
Why the same SQL Server procedure is fast for one value and painfully slow for another, or fast in SSMS but slow in your application, how to confirm it is parameter sniffing, and six fixes with when to use each.
Learn what SQL indexes are, how they speed up queries, which columns to index, and when an index can slow you down.
Struggling with Query Timeout errors or sluggish performance in your Delphi and SQL Server application? Discover 5 practical, battle-tested fixes
