Achievement Unlocked: 24 Hours of Pass Session Submitted
I have finally submitted a session for a speaking engagement. Those who know me know that this is a very...
2015-03-19
745 reads
Blog Posts
Audit Schema Change Report
In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion....
2015-03-19 (first published: 2015-03-11)
6,692 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...
2015-03-19
46 reads
Azure SQLDatabase v12 Premium Editions and Available Cores
A couple of days ago, during the great SQL Unplugged live show, I have asked a couple of questions the...
2015-03-19
873 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
48 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous...
2015-03-19
42 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous Deployment Do you want to get your databases...
2015-03-19
16 reads
Free Professional Advice on Setting up Continuous Integration for Sql Server Databases
Calling all London/Sussex Sql Developers does this sound like you?
Would you like to set up Continuous Integration or Continuous DeploymentDo...
2015-03-19
415 reads
Getting Under The Hood
Whenever a piece of software does something that makes me think this is awesome I find myself blocking out the...
2015-03-19
60 reads
Planning a High Availability and Disaster Recovery Plan in Madison, WI
I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster...
2015-03-19
1,191 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