New SQL Server Blog Author Challenge
My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...
2015-03-23
465 reads
Blog Posts
Review of Minion Reindex
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all...
2015-03-23 (first published: 2015-03-16)
7,906 reads
Selected as a PernixPro
Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to...
2015-03-23
410 reads
Speaking at SQL Saturday #389 – Huntington Beach
I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM...
2015-03-23
914 reads
Speaking at SQLSaturday 376 Budapest
On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!
I will be speaking about one of my...
2015-03-23
551 reads
Announcing the SQL New Blogger Challenge!
TL;DR – In April, I’m challenging myself to write (and publish!) here regularly, and I’m extending an open challenge to other new...
2015-03-22
340 reads
Announcing: SQL Saturday Baton Rouge 2015
SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!
Email or instant message your friends, post...
2015-03-22
760 reads
Career Ratings
I wrote the other day about measuring your career, and I gave some general advice, but I wanted to give...
2015-03-20
1,467 reads
Lessons Learned from a Poor-performing VIEW
It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...
2015-03-20 (first published: 2015-03-12)
8,924 reads
Monitoring for Timeouts
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...
2015-03-20 (first published: 2015-03-12)
7,644 reads
Blogs
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
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...
Forums
ALAMAT BCA KCU TEGAL Tlp:08218154374
Hub Via Wa 628218154374 Alamat Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim.,...
ALAMAT BCA KCU SALATIGA Tlp:08217555651
Hub Via Wa 628217555651 Alamat Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo,...
ALAMAT BCA KCU PEKALONGAN Tlp:0817825533
Hub Via Wa:62817825533 Alamat Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa...
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_CustomerPhone
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.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers