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
Blog Posts
PASS Keynote Day #3: Dr. Dewitt
And we’re off. We opened with a video of people saying “Connect, Share, Learn” and “This, is Community”
Rob Farley & Buck...
2011-10-14
1,339 reads
PASS Keynote Day 3
Wow,
It’s the last day of the 2011 PASS Summit. I can’t wait to get some sleep on the plane tomorrow.
Wayne...
2011-10-14
785 reads
PASS Summit 2011 – Keynote Day #3
Final day at the PASS Summit. That means it’s time to hear from David Dewitt. This is the keynote of...
2011-10-14
590 reads
PASS Summit 2011 Day 3 – Keynote Live Blog with Dr. DeWitt!
Today’s keynote with Dr. DeWitt starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-14
1,684 reads
PASS Summit Keynote Day 2
Bill Graziano opened the day with some very white knees as kilt day kicked off at the Summit this year!...
2011-10-14
844 reads
Slides & Samples for my Advanced SQL Server Troubleshooting session at SQLPASS
As I have announced in my "Advanced SQL Server Troubleshooting" session at SQLPASS
today, you can find here the
slides & samples for...
2011-10-14
783 reads
Speaking at the 2011 Carolina Technology Conference
On Tuesday, October 18, 2011, I will be speaking at the Carolina Technology Conference in Columbia, SC. I'm scheduled for...
2011-10-14
1,409 reads
SQL PASS Summit 2011 Recap
This week has been an exciting and memorable week for me. The last PASS Summit I attended was in 2009...
2011-10-14
1,843 reads
SQL PASS Summit–Final Day (Keynote)
Got to David DeWitt’s Keynote a bit late so this will not cover as much as normal. (For the record,...
2011-10-14
490 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