A Performance Comparison of INSERT TOP (N) INTO a table versus INSERT with SELECT TOP (N). The first is clearly faster, but the two can give very different results.
TechEd Sri Lanka 2010: Two Sessions and a Room Full of Questions
TechEd Sri Lanka ran at Waters Edge in Colombo from February 8 to 10, 2010, and I presented two sessions there. This post looks back at the index session, rated 8.9, and the change data capture session, rated 7.8, and what each one still teaches. It also shares attendee feedback and photos of the people who made the event.
SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
SQL Server 2008 data and page compressions cut disk space and I/O. I explain ROW and PAGE compression and how to set them on tables, indexes and partitions.
SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance
My online follow up session for Hyderabad Techies covered SQL Server index maintenance: detect, create and rebuild. Over 50 people joined and asked questions.
SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review
I presented a session on SQL Server indexes at Microsoft User Group Hyderabad, led by Hima Vindu Vejella. The index talk was very well received.
SQL SERVER – Plan Recompilation and Reduce Recompilation – Performance Tuning
Plan recompilation hurts performance just like a first compile. Learn what causes it, from schema changes to SET options, and how to reduce recompilation.
SQL SERVER – Find Statistics Update Date – Update Statistics
Stale statistics can hurt a query plan. Use STATS_DATE to find the statistics update date for each index, then update them if they look outdated.