SQL Server Indexed Views Explained
Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...
2012-05-02
58 reads
Eight Words
I remember a lot of things about that day. It was July in Texas, which is to say, it was...
2012-05-03 (first published: 2012-05-02)
2,560 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,792 reads
Notes from SQLSaturday #107 in Houston
I’ve deliberately waited a bit to write this after the event, just to see what stood out after a week...
2012-05-01
467 reads
Favorite DBA Books
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...
2012-05-08 (first published: 2012-05-01)
5,376 reads
The 2012 Powershell Scripting Game(shows) in review
Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it...
2012-05-01
1,199 reads
May Question: How soon will you begin implementing SQL Server 2012?
Now that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server...
2012-05-01
1,046 reads
When Will You Upgrade to SQL Server 2012?
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,251 reads
Speaker Issues: The Quandry of Double Submitting
This is in response to yesterday’s Twitter conversation, and subsequent blog by Eddie Wuerch, about submitting to more than one...
2012-05-01
792 reads
Denali — Day 1: Tempdb Compatibility – Bug?
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
472 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