2011-10-14
Blog Posts
2011 PASS Summit–Report #3
Friday morning keynote. Quick intro from Rick Heiges. Buck Woody and Rob Farley singing, quite the sight for Friday morning....
2011-10-14
633 reads
Cloud? Chotto Matte Kudasai.
If you're not familiar with Chotto matte kudasai, it means "A moment, please," in Japanese. The cloud is big news....
2011-10-14
1,210 reads
Day 6: Friday PASS Summit 2011 Keynote Live
Hello Dear Reader! Welcome to the final day of the PASS Summit and the Keynote address by Dr. David J...
2011-10-14
471 reads
Final Summit Keynote – NoSQL = Not Only SQL
The keynote started out with Rob Farley and Buck Woody singing an awesome song about a slow running query. What...
2011-10-14
1,627 reads
Formula engine and storage engine in SSAS
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. ...
2011-10-14
1,237 reads
Liveblog for Day 2 Keynote at SQL PASS Summit 2011
There are four racks of servers and storage on stage for today’s keynote complete with roaring fans and flashing lights....
2011-10-14
606 reads
My Election Questions Mystery Machine
So last year in improved transparency move, the board and the nomination committee began posting the questions the noncom asked...
2011-10-14
862 reads
PASS Community Summit 2011 Day 3 Keynote
Dr. DeWitt has spokento the PASS Summit for the past two years – turning what was otherwise a veryforgettable “day 3”...
2011-10-14
803 reads
PASS Community Summit 2011 Day 3 Keynote
Dr. DeWitt has spoken to the PASS Summit for the past two years – turning what was otherwise a very forgettable “day 3” keynote slot into a must-see event...
2011-10-14
9 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