So you are in Melbourne on Feb 20th and have nothing to do. What are your options? how about going to SQL SATURDAY!!
I’m doing a session on how to index for optimal performance. Indexing is one of the magic switches in SQL Server that is often misunderstood and can make the difference in a query returning in milliseconds, seconds, minutes or even hours. I’m going to be taking a look at how indexes fragment, explain the impact of the fragmentation and what is happening under the hood. We’ll also touch on some common and not so common index creation, maintenance and optimization techniques.
Hope to see you there.