SQL Server Query Optimization – Introduction

-> This is an Introduction blog post in a series of posts about optimizing SQL Server queries :-

-> SQL Server Parameter Sniffing
-> @@FETCH_STATUS -9
-> What DBCC SHOW_STATISTICS tells me
-> Trace Flag 7471
-> Tempdb contention
-> SQL Server Triggers and Insert performance
-> Optimize for ad hoc workloads
-> Why Bookmark Lookup is BAD?
-> Optimizing Queries using XML in SQL Server
-> Slow query performance with Table Spool operator

Thank You,
Vivek Janakiraman

Disclaimer:
The views expressed on this blog are mine alone and do not reflect the views of my company or anyone else. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.

5 thoughts on “SQL Server Query Optimization – Introduction

  1. Pingback: SQL Server Parameter Sniffing - JBs Wiki
  2. Pingback: Tempdb contention - JBs Wiki
  3. Pingback: SQL Server Triggers and Insert performance - JBs Wiki
  4. Pingback: Optimize for ad hoc workloads - JBs Wiki
  5. Pingback: Why Bookmark Lookup is BAD? - JBs Wiki

Leave a Reply