Tech Ed 2009: Best of Tech Ed Winners Announced
The best of Tech Ed in Los Ageles award winners were selected from Windows IT Pro and SQL Server Magazine,...
2009-05-15
498 reads
Blog Posts
Where's the Phantom Power?
Phantom power, also called Vampire power, is power that's used by electronic devices even though they're powered off. I've also...
2009-05-15
915 reads
An Open Letter To Amazon
I sent this to their customer service, but it highlights a problem with the Kindle process.
I have a Kindle, and...
2009-05-14
409 reads
Taking the Hyper-V Plunge
Or at least I’m getting ready to take the plunge into using Hyper-V. In my machine dilemma, I decided to...
2009-05-14
1,662 reads
TechUpdate Kosova (13th May 2009)
Yesterday, in Prishtina - capital city of Kosova, has been held the TechUpdate Seminar 2009 from Microsoft, organized from the Microsoft...
2009-05-14
1,022 reads
Book Review: What Got You Here Won't Get You There
I've been reading What Got You Here Won't Get You There by Marshall Goldsmith over the past couple months, and...
2009-05-13
765 reads
Database Mirroring FAQ: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
This question was...
2009-05-13
1,665 reads
Loading up on MVP Goodies
Not MVP logo items, as I’m not sure if I really want to wear those. I was somewhat uncomfortable last...
2009-05-13
957 reads
Notes from the May 12, 2009 oPASS Meeting
Our most recent meeting was May 12, 2009, and we had 23 attendees. We started off the evening with news...
2009-05-13
590 reads
The Windows 7 RC Download Issue
A better explanation from the SQLCAT team in this blog entry. I’d still like to see more, but this makes...
2009-05-13
658 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