Re-blog – February 10 – February 16
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-17
614 reads
SQL Server 2012 (“Denali”): Microsoft StreamInsight
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,150 reads
Performance VC Feb Meeting
Jes Borland will be speaking for the Performance Virtual Chapter this month. Don’t miss out on this free training. Here...
2012-02-17
755 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
53 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor...
2012-02-17
1,418 reads
Speaking at MagicPASS on February 22, 2012
Next Wednesday I’ll be returning to MagicPASS to do a presentation on SQL security for developers. It’s an interesting topic,...
2012-02-17
682 reads
Building Visual Studio Deployment Projects With MSBuild
I recently hit what I would call a fairly serious limitation of MSBuild and that is that it cant build...
2012-02-17
163 reads
SQL Server – read only database status
This post describes how to return the database read-only status via T-SQL .
The system view – sys.databases returns a column called...
2012-02-17
1,124 reads
2012-02-17
5 reads
2012-02-17
9 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