AHHH I need a Blog Topic!!!
One of the hardest things you can do as a blogger is to come up with a post topic. Do...
2017-12-20
350 reads
Blog Posts
Capture Index Maintenance Operations
One good database maintenance practice is to keep the indexes in good working order. This is typically done via index...
2017-12-20
662 reads
Capture Index Maintenance Operations
If an application vendor has something built into their code to perform index maintenance, unbeknownst to you, that is a near-worst case scenario.
Related Posts:
Where is that Mask? December 28,...
2017-12-20
9 reads
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up...
2017-12-20
377 reads
Interview with Guy In A Cube’s Adam Saxton and Patrick Leblanc
Since starting the Guy In A Cube series over three years ago, Adam Saxton has become the front man for...
2017-12-20
362 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
354 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
965 reads
My Second Pester Test
I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I...
2017-12-20 (first published: 2017-12-07)
2,114 reads
Our SQL Server 2017 Administration Inside Out fun author survey
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
803 reads
UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.
From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...
2017-12-20 (first published: 2017-12-08)
1,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
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