SQL Server Education (by the geeks, for the geeks)
Does Column order in where clause matters? Whenever I have any doubt, I always play around with it to clarify my doubt. While doing experiment with index operation, I learnt something …
Column order and equality operator on Index Read MoreIndex is one of most widely discussed topic among developers and DBAs. During query optimization Index is one of the important aspects. I came across multiple instances where Developer/ DBA creates …
Index Selection Fundamental Read MoreI 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 MoreAn index is a way to speed up performance of a query in SQL Server. An index is a B-Tree structure on a table column or set of columns referred as …
Index seek vs Index scan in SQL Server Read MoreHi Friends, Recently I completed my blog series on execution plans which I hope helped you to understand on the basics. Couple of days back, I got a message in one …
SQL Server impact of different collation and query plan Read MoreHi Friends, I had started the SQL Server index internal series sometime back. The first part is here; Apologies for making it late on Part 2 – this part is more …
SQL Server Index Internals Part 2 – Why is the Optimizer SEEKING instead of SCANNING Read More