question

erlokeshsharma08 avatar image
erlokeshsharma08 asked

indexes and index fragmentation

Please suggest a good read (a deep dive) or a book on following topics:- Index Index Fragmentation Thanks
indexingfragmentation
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

erlokeshsharma08 avatar image erlokeshsharma08 commented ·
Thanks Anthony, If I may ask which book you suggest will act as a bible for deep understanding of concepts such as indexes, query plans, partition ?
0 Likes 0 ·
anthony.green avatar image anthony.green commented ·
There are so many. http://www.sqlservercentral.com/Books/ http://www.sqlservercentral.com/stairway/ http://www.brentozar.com/sql/table-partitioning-resources/
0 Likes 0 ·

1 Answer

·
anthony.green avatar image
anthony.green answered
The following link may be a good start http://www.sqlservercentral.com/stairway/72399/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.