Explicitly naming CL key columns in NC indexes – when and why
This morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that
This morning, as I was prepping for my PASS Data Architecture Virtual Chapter presentation on “Why Physical Database Design Matters,” I went to tweet that
There’s a lot of confusion around duplicate indexes and I think a lot of it has to do with how sp_helpindex (or even SSMS) display
OK, I've talked about the clustering key many times. Here, I thought I'd bring together one final series of details (and links) to help you
NOTE: I’ve released other versions of sp_helpindex since this post. Check out the category: sp_helpindex rewrites for all of the options! OK, I first blogged about
Time flies when you're having fun, eh? This week Paul and I are in Dublin, Ireland delivering a deep technical "SQL Immersion Event" on Internals,
OK, for years I've been saying that SQL Server doesn't care about the order in which you define the columns of your table because internally
Recently, the SQL Server 2008 Internals title was released (and only in the past few days have people actually received their copies)! In fact, I still
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.