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.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.