April Question: What’s your favorite DBA book, and why?
Over and over again, I get asked which DBA books I recommend. With this in mind, this month’s qustion is...
2012-04-01
1,113 reads
Slides & Samples for my DevWeek and SQLbits sessions
As I have announced in my DevWeek and SQLbits sessions, you can find my session materials
(slides & samples) here for download:...
2012-04-01
828 reads
Announcing SQLSaturday #175–In Flight Edition
One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...
2012-04-01
691 reads
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to...
2012-04-01
3 reads
SQL 2012 has Launched
LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it,...
2012-04-01
989 reads
Monitor SQL Server Backup job duration
if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...
2012-03-31
1,921 reads
Reflections on Leaving Microsoft
Reflections on Leaving Microsoft
Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)
Several members of my SQLFamily have made adjustments to their career...
2012-03-31
2,304 reads
Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,671 reads
Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,524 reads
Remote DAC connections
TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...
2012-03-31
1,899 reads
Blogs
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
Question of the Day
Rebuilding All Indexes
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContactAfter I do this, what will I see for the index status? See possible answers