SQL Server Education (by the geeks, for the geeks)
I was working on removing duplicate indexes from a table. Before removing an index usually I check whether that index is used by any query or not, is there any index …
Clustered Index seek doesn’t guarantee optimal Query plan Read MoreHi Geeks, Last three days we have been discussing on SQL Server Key Lookup operators and if you are reading this post ahead of them, I recommend you to read Part1 , …
SQL Server Key Lookup Operator – Part 4 Read MoreHi Friends, Continuing from yesterday’s post on Non-clustered Index seek operation, obvious question is what happens if non clustered index does not contain all columns requested by statement(s)? To find an …
SQL Server Key Lookup Operator– Part 1 Read MoreHi Geeks, SQL Server index seek nonclustered uses a non-clustered index to perform search operation. The statement below illustrate a non-clustered index seek operator. USE [AdventureWorks2012] SELECT Address.AddressID, Address.StateProvinceID FROM Person.Address …
SQL Server Index Seek Nonclustered Read MoreHi Friends, In last two blog posts of this series Part 8 and Part 9 I’ve explained SQL Server execution plan using INSERT, UPDATE statements. You guessed it right; today we would cover …
SQL Server Execution Plan – Simplifying : Part 10 Read MoreDear Friends, In my previous blog post, Part 8 of this series we analyzed SQL Server execution plan using INSERT statement. Today, we will try UPDATE statement followed by explanations. Let us …
SQL Server Execution Plan – Simplifying : Part 9 Read MoreDear Friends, SQL Server engine generates SQL Server execution plan for all SQL queries in order to figure out best path of execution when we submit any request. In my previous …
SQL Server Execution Plan – Simplifying : Part 8 Read MoreHi Friends, In my previous blog post Part 6 on this series we saw how SQL Server execution plan changes when we use ORDER BY clause in SELECT statements. Today, we …
SQL Server Execution Plan – Simplifying : Part 7 Read MoreHi Friends, When we add some basic clauses to our queries, different operators are being displayed in the SQL Server execution plan. Today we will have a look when we introduce …
SQL Server Execution Plan – Simplifying : Part 6 Read MoreHi Friends, I hope you are finding this series useful and read my previous posts Part1, Part2, Part3 and Part4 where I covered different operators. Today I’m going to talk about two …
SQL Server Execution Plan – Simplifying : Part 5 Read More