February 2, 2009 at 8:31 am
We have some new employees who don't know everything about indices yet and i want to teach them everything there is. But i rather not spent 2 hours telling all about clustered / nonclustered, pagefullness, pagesplits, reading execution plans, etc. etc.
So i was wondering: does someone know some realy good help files about this subject?
February 2, 2009 at 8:45 am
You might try MSDN for that. All the data is there, as published by Microsoft.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2009 at 9:30 am
I agree MSDN. You might also see if there's an introductory DBA book that has a good chapter on it.
"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
February 2, 2009 at 11:56 am
Hi
Check out the below link
http://www.odetocode.com/Articles/70.aspx
Thanks -- Vj
February 2, 2009 at 1:35 pm
Not a free white paper I'm afraid. The best source I've found for information about indexing has been Kalen Delaney's book Inside SQL Server; Itzik Ben-Gan's Inside TSQL Querying book also has a very detailed chapter on the subject, and it's from a slightly different perspective to Kalen's, which I found very helpful. Both are in-depth, however, to put it mildly. The last book in the 'Inside SQL' series for 2005 - Querying Tuning and Optimization - has more of an overview of the subject.
February 2, 2009 at 11:47 pm
Vijaya Kadiyala (2/2/2009)
Check out the below link
http://www.odetocode.com/Articles/70.aspx
Thanks -- Vj
http://dotnetvj.blogspot.com[/quote%5D
Thanx, this is a nice start for them 🙂
@ the others: thanx for your responce. Ofcourse i already know MSDN, but in this case i wasn't looking for that 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply