The Basic TRY..CATCH
Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct...
2015-03-24
1,194 reads
Blog Posts
The shaky bug in SSIS
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012...
2015-03-24
759 reads
Use the WordPress Revision Counter to Keep Shipping Posts
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve...
2015-03-24
710 reads
Using New-TimeSpan to convert friendly time
The question was this:
This is just a quick/fast snippet in response to that question, but I can think of a...
2015-03-24
464 reads
Who is cjsommer?
I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...
2015-03-24
262 reads
0 to Speaker
Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...
2015-03-23
699 reads
Exam Prep 70-463: Executing packages in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-23
1,083 reads
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,410 reads
Getting out of the ground with TSQL Smells.
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...
2015-03-23
698 reads
How to resolve Space issue in SQL server 2005 TIP #93
Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...
2015-03-23
783 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