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.
SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT
INSERT TOP (N) INTO a table is not the same as INSERT with SELECT TOP (N). My example from a client training shows how the two methods differ.
QUOTENAME Object Names: Quote Each SQL Server Name Part
QUOTENAME object names separately to keep each part of a qualified SQL Server name intact. The function surrounds its entire input with identifier delimiters. A dot inside that input stays inside one quoted name. I keep the schema and object in separate variables.
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.