Indexes: just because you can, doesn’t mean you should!
I've decided to create a new series of posts – just because you can, doesn't mean you should! These are going to go in a
I've decided to create a new series of posts – just because you can, doesn't mean you should! These are going to go in a
I realize that I’ve created quite a few posts (and rewrites) around sp_helpindex and recently I’ve been recommending that most folks use my latest version
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
Paul's hosting the T-SQL Tuesday theme this month and the theme revolves around DBA skills. Specifically, "why are DBA skills necessary?" His specific post
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
When SQL Server 2008 was in beta, Paul and I worked on a project to create content that would "jumpstart" folks in learning and working
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,
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
I started the series here: https://www.sqlskills.com/blogs/kimberly/post/Spring-cleaning-your-indexes-Part-I.aspx and I want to continue with Part II today by clarifying some great questions/comments that have come up on the
First and foremost, happy spring! I truly hope we’re on the path to summer (although who would know it here – we’re in Florida for
When you decide to rebuild or reorganzie an index, you have an option to set something called FILLFACTOR. This is probably the MOST IMPORTANT thing
OK, it seems as though there's A LOT of confusion about what steps are required for proper database maintenance. And, it seems as though some
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.