The NOINDEX option does change the behavior of DBCC CHECKDB (even if you’re already using PHYSICAL_ONLY). Here’s how the two options compare to one another, and how to see the difference yourself in a simple example.
You need to change an INT column to a BIGINT in a large table. Learn why this schema change can make your transaction log explode, and how to avoid it.
You’ve got 99 problems, and the request coming in ain’t one.
Maybe you need to channel your inner Cat DBA, just for a moment.
SQL Saturday Oregon will be held on Oct 22, 2016 this year– the weekend before the SQL PASS Summit.
As a Portlander, I love it when people come visit my town! Please consider taking a few extra days to enjoy checking out PDX before or after the event.
What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?
Psssttt – I have an updated blog post on this called the Learner’s Guide to SQL Server Performance Tuning
The SQL Server is slow, what should you do? I answer a reader question and share my strategy for performance troubleshooting.
In this episode of “Dear SQL DBA,” I answer a question about early adoption of SQL Server, discuss why testing in production isn’t necessarily crazy, and recommend how to handle requests to upgrade your SQL Server to use new features.
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.