SQL Server with Mr. Denny

Jun 30 2011   2:00PM GMT

SQL Excursions and Index Internals #sqlexcursions



Posted by: Denny Cherry
Tags:
Indexing
SQL Excursions
SQL Server

The fourth session that I’ll be giving at SQL Excursions will be on index internals.

In this session we’ll dig into the internal structures of indexes.  We will explore the differences between clustered and non-clustered indexes, what’s laid out within each page of the indexes and how the SQL Server uses the data within the indexes to find rows quickly.

Knowing how indexes actually work is key to understanding why indexes improve query performance.  Knowing that indexes will help performance is good (and hopefully you know this), but knowing how the index actually works is even more important so that you can make proper indexes so that you aren’t making extra indexes that aren’t needed as having to many indexes will actually slow down SQL Server not make it faster.

If you haven’t signed up yet, now is the time.

See you in Napa September 22nd-24th,

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: