To Do: Win Great SQL Training and a Cruise
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,909 reads
Blog Posts
Brad McGehee talking about tempdb issues
Brad presented a session that tries to help you identify and fix tempdb problems. Performance monitor is your friend. the...
2011-03-30
1,857 reads
Brian Kelley on Security at SQL Server Connections
Random notes from Brian Kelley’s security talk. Brian spent a number of years working a a security guy for a...
2011-03-30
1,899 reads
Dude, where’s my memory?
A session I have wanted to see. Marciej Pilecki has done this before with high ratings and I have missed...
2011-03-30
1,665 reads
I laughed, I cried, it was better than CATS: The Fast Track Data Warehouse 3.0 Reference Guide
Careful what you say about cats, lady.
You know what’s crazy?
A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with...
2011-03-30
1,801 reads
Improving Meetings
Most folks I know hate meetings. They especially hate meetings about meetings. Recently I was working with a developer who...
2011-03-30
2,101 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with...
2011-03-30
3,895 reads
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have...
2011-03-30
16 reads
SQL Saturday #74 Jacksonville
For the 4th year SQL Saturday comes to Jacksonville, FL this year on April 30, 2011. Many of you already...
2011-03-30
1,514 reads
Tampa IT Camp 2011 Lessons Learned Part 1
On Saturday, March 19th 2011 we held the first ever Saturday “code camp” style event for the IT Pro (Sys...
2011-03-30
1,745 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