Advertisements

SQL Performance Tuning & Optimization


SQL Performance Tuning

SQL Server Query Performance Tuning and optimization is a very vast topic. So lets go step by step. Lets first understand some of the basic concept and terminology used while we talk about SQL Performance Tuning. Gradually we will move towards the advance concepts in there and how to we can queries in a better manner.

# Notes Details Link
49 SQL Performance Tuning | Never use Count(*) in If Exists() for data existence in a Table. Why? NA
48 SQL Performance Tuning | Table Variable are stored in TempDB NA
47 SQL Performance Tuning | How to select records from one table that do not exist in another table? – Different Methods & the Best Method NA
46 SQL Performance Tuning | Best way to check if data exists in a table ? NA
45 SQL Performance Tuning | COUNT(1) Vs COUNT(*) Vs COUNT(100) | Which one is fastest? NA
44 SQL Performance Tuning | Best way to Handle NULLS in Joins NA
43 SQL Performance Tuning | SQL Server – Logical Binding Order or Logical Query Processing Phases NA
42 SQL Performance Tuning | Data Compression NA
41 SQL Performance Tuning | SQL Server Predicates – Seek & Residual Predicates NA
40 SQL Performance Tuning | SQL Server – Logical and Physical Operators NA
39 SQL Performance Tuning | Table Variables & Estimated No of Rows NA
38 SQL Performance Tuning | Types of Spools in Execution Plan – Deep Dive NA
37 SQL Performance Tuning | How to handle large number of insertions in SQL Server? NA
36 SQL Performance Tuning | Where CTEs are stored? NA
35 SQL Performance Tuning | How to write optimized queries NA
34 SQL Performance Tuning | How SQL SERVER handles duplicate values in an index? NA
33 SQL Performance Tuning | Execution/Query Plan Operator – The Concatenation NA
32 SQL Performance Tuning | Why Lookups are bad for performance? NA
31 SQL Performance Tuning | Spools in Execution Plan. Are they bad? NA
30 SQL Performance Tuning | What you should look in execution plans? NA
29 SQL Performance Tuning | How to avoid/eliminate/remove ORDER BY from SQL Queries? Download
28 SQL Performance Tuning | Table Variable – Estimated no of rows = 1 | No Statistics? Download
27 SQL Performance Tuning | Execution/Query Plan Operator – The Sort Operator – Part II, Which sorting algorithms used by SQL Server? Is it blocking or non-blocking? Download
26 SQL Performance Tuning | Execution Plan Operator – Properties, Types – Blocking / Non-Blocking? Download
25 SQL Performance Tuning | Why Order By is bad in Queries? / Execution/Query Plan Operator – The Sort Operator Basics Download
24 SQL Performance Tuning | What is Selectivity? How we can use this in creating our indexes? Download
23 SQL Performance Tuning | What are the internal methods of Physical Operators? How they work? Download
22 SQL Performance Tuning | What controls an Index Scan to read all pages from leaf level? Or An Index scan operator always reads all pages from leaf level? Download
21 SQL Performance Tuning | Implicit Conversions are Bad for Performances? Why? Download
20 SQL Performance Tuning | How to find latest order Id from Orders table for each product? (Top n orders for each product) Let’s write a better query. Download
19 SQL Performance Tuning | How to properly read an Execution Plan/Query Plan? Download
18 SQL Performance Tuning | LIKE IS SARGable, How to write better Where Clause –II. Let’s Check? Download
17 SQL Performance Tuning | CAST IS SARgable, How to write better Where Clause. Let’s Check? Download
16 SQL Performance Tuning | Update Statistics – Synchronously and asynchronously. Which one is better? Download
15 SQL Performance Tuning | Why we should update statistics? When one should update statistics? Download
14 SQL Performance Tuning | Avoid Using Function in WHERE Clause. Why? Download
13 SQL Performance Tuning | What is Plan Cache? Why it is important? Download
12 SQL Performance Tuning | Raw SQL Vs Stored Procedures? Download
11 SQL Performance Tuning | Estimated Execution Plan versus Actual Execution Plan? Download
10 SQL Performance Tuning | Execution Plans? Download
9 SQL Performance Tuning | Which one is better | Temp Table or Table Variable? Download
8 SQL Performance Tuning | Don’t ever do SELECT *. It’s really a bad idea. Why? Download
7 SQL Performance Tuning | Indexes – Part 4 Download
6 SQL Performance Tuning | Indexes – Part 3 Download
5 SQL Performance Tuning | Indexes – Part 2 Download
4 SQL Performance Tuning | Indexes – Part 1 Download
3 SQL Performance Tuning | Performance issues due to bad statistics? Download
2 SQL Performance Tuning | What are Statistics and what do they do?
Download
1 SQL Performance Tuning | What is Query Optimizer & how it works
Download
Advertisements

Leave a comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s