24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
762 reads
Blog Posts
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may...
2011-09-27
776 reads
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may have to rethink one of the answers given during...
2011-09-27
11 reads
How Should We Pay People?
It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some...
2011-09-27
1,168 reads
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...
2011-09-27
1,482 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,412 reads
NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
772 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,247 reads
SQL Saturday in Iowa City This Weekend
In just a few short days, it will be time for SQL Saturday #98 in Iowa City. If you’ve got...
2011-09-27
716 reads
SQL University SSIS : Named Pipes -- Producer
Yesterday, I set up the premise for using named pipes in SSIS. Today we are going to get into the...
2011-09-27
695 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
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
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