Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going to see some great presenters this morning.
I’m glad I picked interviewing as the topic of TSQL Tuesday #93, because people wrote posts chock full of great advice and funny stories. Get ready to learn, be amazed, and laugh out loud as you read these posts, which I’ve indexed by the author’s first name. Don’t blame these authors for the dorky jokes in the cartoons, though. That’s all my fault.
Aaron Bertrand is “looking back at bad interviews.” In the comments, I give a sure-fire way for you to handle any technical interview questions you don’t know.
I see HEAP tables are found even when I know those tables have a clustered index, and I see a lot of forwarded records. This happens to 5 tables in my database. I can see the clustered and in some ones the non-clustered indexes… why are some scripts reporting them as heaps?
SQL Server has two types of filtered indexes:
It’s the week of the largest SQL Server conference, the SQLPASS Summit. I’m in Seattle with more than 6,000 other SQL Server professionals. I made it to the Keynote this morning, only to find Rob Farley sitting next to me.
I’ve got a cold and I was waiting for the DayQuil to kick in when the Keynote began. If you’ve ever met Rob, you know I was in no danger of falling asleep.
The bigger your indexes are, the harder your index maintenance falls. Is it better to rebuild big indexes? Or should you reorganize?
I can’t wait to teach my full day course, SQL Server Index Formulas: Problems and Solutions in Seattle at the PASS Summit on Tuesday, October 25th. Woot! Less than 3 weeks away!
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.