Here are the resources for my Summit 2010 sessions.
Lightning Talk – Page Compression
- Creating Compressed Tables & Indexes
- Row Compression Implementation
- Page Compression Implementation
- Data Compression: Strategy, Capacity Planning and Best Practices
Heaps of Trouble, Clusters of Glory – A Look At Index Internals
- Kimberly Tripp’s sp_SQLskills_SQL2008_helpindex
- http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
- http://www.sqlskills.com/blogs/paul/post/Inside-the-Storage-Engine-IAM-pages-IAM-chains-and-allocation-units.aspx
- Overhead in Non-Unique Clustered Indexes
- Index Defrag Script, v4.0
- http://sqlfool.com/2009/04/filtered-indexes-what-you-need-to-know/
Great SQLPass presentation on indexes. Your link at http://sqlfool.com/Summit2010/ to the index-defrag-script returns page not found.
Thanks for the session. Great Information and a spectacular Demo! Simply enjoyed it. I mentor students of all ages and backgrounds at little to no cost (coz i enjoy it!) and know the amount of effort it takes towards such a high quality presentation. Keep it up!
Hi Michelle, i was in your “Heaps of Trouble..” summit 2010 sessions. Can you post the scripts for that sessions? Also the above links for this session are not working. Could you please fix them? Thank you.