April 26, 2010 at 1:42 am
Hey
I was just wondering if anyone can point me in the direction of some resources that give some in depth detail about how SQL server goes about building/re-building index structures. Things like how is picks up the data in the table, sorts it appropriately and puts it all back on disk, that type of thing.
Cheers
JQ
April 26, 2010 at 7:16 am
I'd start off with the Books Online. It covers a very large swath of this material right off the bat. After that, do a search on MSDN. Any time you're starting to learn about any part of SQL Server, those should be the initial resources. It's after you've exhausted them that you branch out and start looking for articles, blog posts, books...
As far as books goes, Kalen Delaney's Inside SQL Server books are pretty defnitive on any information of this type.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply