SSIS – Can’t Enable/Disable within Data Flow Tab
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from...
2011-10-21
3,040 reads
Blog Posts
Why is -fill in the feature- Enterprise-Only?
Steve Jones (Blog/@Way0utWest) recently wrote a great blog post proposing that Microsoft should go from having edition-only features (most of...
2011-10-21
436 reads
Best PASS Summit Ever (so far)
I have to admit that the 2011 PASS Summit was such an amazing experience and there was so much to...
2011-10-20
693 reads
Denver SQL Server User’s Group Meeting on October 20, 2011
The Denver SQL Server User’s Group will be having their monthly meeting tonight at the Microsoft office in the Denver...
2011-10-20
732 reads
Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-20
21,503 reads
Jeremy Huppatz presents Row Versioned Data Warehouse
Subject: Row Versioned Data WarehousesLevel: 200-300 (Intermediate)
Start Time: Thursday, December 15th, 2011 8:00 PM US Central Time
Presenter: Jeremy Huppatz...
2011-10-20
510 reads
PASS Board Of Elections: Adam Jorgensen
Be Part Of The Solution, Not The Problem
<disclaimer >
Now that BoD season is in full swing and I’m not running for...
2011-10-20
1,458 reads
Penance
Buck Woody wrote a fantastic post this morning for speakers to think about. All too often I have seen some...
2011-10-20
1,846 reads
Setting up SSIS Auditing Part 2
Auditing in SSIS can be a real headache. In this two part series blog I am going to try to...
2011-10-20
3,591 reads
SolidQ Announces BI Center of Excellence
Carl Rabeler, SharePoint and SQL BI Expert Formerly With Microsoft SQLCAT, Rejoins SolidQ as Director of the Business Intelligence Center...
2011-10-20
909 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