Summit 2010 Resources
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/
Categories
- Business Intelligence
- Internals
- Miscellaneous
- PASS
- Performance & Tuning
- Presentations
- SQL 2008
- SQL Tips
- Syndication
- T-SQL Scripts
Subscribe to my blog!
| Like what you see? Subscribe! |
 |
Around the Web
Recent Tweets
- [New Blog Post] A Question For My Blog Readers http://t.co/QPwN5yGw #SQLServer #Teradata
- GoDaddy is looking for a rockstar Teradata expert. Great opportunity on a high-visibility project. Come work w/ me! :) http://t.co/NE2EHnkf
- @datachick grass is always greener on the other side. I think that's why my daughter prefers to eat broccoli off my plate instead of hers
Archives
- February 2012
- November 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
March 16th, 2011 - 16:01
Great SQLPass presentation on indexes. Your link at http://sqlfool.com/Summit2010/ to the index-defrag-script returns page not found.
April 14th, 2011 - 14:51
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!
November 20th, 2011 - 11:22
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.