The Holy Trinity: Indexes, Execution Plans and the Optimizer

  • Article

The Belgian SQL Server User Group is organizing another interesting evening full of technical content.

From their website:
"This UG-evening will start with an introduction of the basics of index design (the heap,clustered/non clustered indexes and covering of a query by an index). Later we will discuss how the optimizer works, why it can be wrong (statistics, procedure cache) and how to correct this. Another part of the session will be some advanced features of indexing like partitioning, locking and filtered indexes. We will of course not forget indexed views and computed column indexes. If there is some time left we can also look at spatial indexes and xml indexes

Agenda:
18:00 - 18:30 Registration and welcome with a drink & sandwich
18:30 - 20:00 Part 1 of the session
20:00 - 20:30 pause
20:30 - 22:00 Part 2 of the session
22:00 - ... Networking with your peers"

Hope to see you there! More information on https://www.sqlug.be.

ps. This post was written using the new Windows 7 Beta :-)