Freigeben über

SQLUG Event Thu, January 29: The Holy Trinity for SQL Server DBAs: Indexes, Execution Plans and the optimizer

  • Artikel

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

Speaker: Marc Mertens is trainer at Global Knowledge .

Date: Thursday, January 29th

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

Location: Global Knowledge Mechelen.

We want to remind that registration is obligatory. You can register here.

Technorati Tags: SQLUG,SQL Server,Event