Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,023 reads
Blog Posts
For Your Friday Enrichment: Get Alifeatoll
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
516 reads
Hostettler & the Bottleneckers
A bit of fun !
A long long time ago before the dawn of 2010, somewhere to the South of the...
2011-04-08
617 reads
Notes for Moving BizTalk’s Databases
Yesterday, I was tasked with helping a team move their BizTalk databases to another server. These are my notes for...
2011-04-08
1,438 reads
Powershell Day 8
Day 8 Event Viewver Event log is a very important trace and diagnose the activity on the system. Using Event...
2011-04-08
224 reads
SQL Server, Storage and You
Just a note that I will start my three part webcast, SQL Server, Storage and You next week April 13th...
2011-04-08
1,012 reads
Upcoming Events
If live in Central/South Florida or are planning a trip, we’ve got several IT community events worth checking out…
May
SQLRally in...
2011-04-08
555 reads
A SQL Server Hardware Nugget A Day – Day 7
For Day 7 of this series, I will talk about the incredibly useful CPU-Z utility, which is available for free...
2011-04-07
1,320 reads
I Got Registered!
I’m going to SQL Rally! Are you going to SQL Rally? Have you heard of SQL Rally?
What’s SQL Rally?
I’m glad...
2011-04-07
424 reads
Me Me Me, Event Event Event
Dear Readers,
Today’s blog shall be entirely stream-of-consciousness, which is to say, I don’t know exactly what I’m going to talk...
2011-04-07
816 reads
Blogs
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...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
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_CustomerEmail
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.CustomerContactAfter I do this, what will I see for the index status? See possible answers