Column order and equality operator on Index
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 …
Read MoreSQL 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 …
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 …
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 …
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 …
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 …
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 …
Read More