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

230 thoughts on “SQL Performance Tuning & Optimization”

  1. Pingback: Microsoft SQL Server 2019 | Features added to SQL Server on Linux | Improving my SQL BI Skills

  2. Pingback: Python | Replace NONE by its previous NON None value | Improving my SQL BI Skills

  3. Pingback: Python | How to convert a string to a list | Improving my SQL BI Skills

  4. Pingback: Python | Find unique words from a string | Improving my SQL BI Skills

  5. Pingback: Python | Calculate average word length from a string | Improving my SQL BI Skills

  6. Pingback: Python | Find the number of times a substring present in a string | Improving my SQL BI Skills

  7. Pingback: Python | Find maximum value from a list | Improving my SQL BI Skills

  8. Pingback: Python | How to find GCF of two numbers | Improving my SQL BI Skills

  9. Pingback: Python | How to find LCM of two numbers | Improving my SQL BI Skills

  10. Pingback: Python | How to convert a list to a string | Improving my SQL BI Skills

  11. Pingback: Python | Find common words from two strings | Improving my SQL BI Skills

  12. Pingback: Python | Find un-common words from two strings | Improving my SQL BI Skills

  13. Pingback: Python | How to convert a number into a list of its digits | Improving my SQL BI Skills

  14. Pingback: Python | Print the first non-recurring element in a list | Improving my SQL BI Skills

  15. Pingback: Python | Print the most recurring element in a list | Improving my SQL BI Skills

  16. Pingback: Python | Find the cumulative sum of elements in a list | Improving my SQL BI Skills

  17. Pingback: Python | Check whether an array is Monotonic or not | Improving my SQL BI Skills

  18. Pingback: Python | Check whether a number is prime or not | Improving my SQL BI Skills

  19. Pingback: Python | Print list of prime numbers up to a number | Improving my SQL BI Skills

  20. Pingback: Python | Print elements from odd positions in a list | Improving my SQL BI Skills

  21. Pingback: Python | How to sort an array in ascending order | Improving my SQL BI Skills

  22. Pingback: Python | How to reverse an array | Improving my SQL BI Skills

  23. Pingback: Python | Check a character is present in a string or not | Improving my SQL BI Skills

  24. Pingback: Python | Find the missing number in the array of Ints | Improving my SQL BI Skills

  25. Pingback: Python | How would you delete duplicates in a list | Improving my SQL BI Skills

  26. Pingback: Python | Print positions of a string present in another string | Improving my SQL BI Skills

  27. Pingback: Python | Check whether a string is palindrome or not | Improving my SQL BI Skills

  28. Pingback: Python | Validate an IP Address-IPV6(Internet Protocol version 6) | Improving my SQL BI Skills

  29. Pingback: Python | Count consecutive 1’s from a list | Improving my SQL BI Skills

  30. Pingback: Python | The Print and Divide Puzzle | Improving my SQL BI Skills

Leave a comment

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.