July 6, 2011 at 7:16 am
Hi all,
Thank you for your kind support, co-operation and interest in forum posts.
Can you please help me to find tutorial/articles about A to Z of Indexing in SQL Server.
I want to know "Where to do", "When to do", "How to do" index in sql server tables.
Please refer me best article which guide me basics to ultimate solution of Indexing.
Thank you all.
July 6, 2011 at 7:59 am
Have you had a chance to look on SQL Server Central? The stairway series is quite nice - http://www.sqlservercentral.com/stairway/72399/
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
July 6, 2011 at 8:29 am
That could easily be an entire book (but one doesn't exist)
Start with this series: http://www.sqlservercentral.com/articles/Indexing/68439/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 9:26 pm
You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of just indexes. You have to learn it a chapter here, a paragraph there, an article over that way...
I wonder if a book could be made generic enough to discuss the indexing mechanics of what I see as the big three relationals right now (MSSQL, MySQL, and Oracle) to be worth distribution. I know I could only get involved in the MSSQL portions, I barely understand those enough to dare as it is. I couldn't touch the mechanical side of Oracle or MySQL, I don't think, other then conceptually.
IE: I know Oracle used to use physical disk location as its RID, but I don't know if that's true anymore nor do I know enough about the rest.
Sorry, my ramblings got distracting there...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
July 7, 2011 at 9:36 am
Thank you friends, Both Articles are good enough to understand Indexes....
July 7, 2011 at 9:52 am
Craig Farrell (7/6/2011)
You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of just indexes.
Yet.
I wonder if a book could be made generic enough to discuss the indexing mechanics of what I see as the big three relationals right now (MSSQL, MySQL, and Oracle) to be worth distribution. I know I could only get involved in the MSSQL portions, I barely understand those enough to dare as it is. I couldn't touch the mechanical side of Oracle or MySQL, I don't think, other then conceptually.
For that you'd need someone who was extremely familiar with the architecture, internals and optimiser of all three. I think that will be hard. Comprehensive book on just one of them, very possible.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply