Identifying Blocking via Extended Events
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-02-24
370 reads
Blog Posts
Outlier Detection with SQL Server, part 3.5: The Modified Thompson Tau Test
By Steve Bolton
…………Based on what little experience I’ve gained from writing this series on finding outliers in SQL Server databases,...
2015-02-24 (first published: 2015-02-14)
8,822 reads
Please Throw this Hardware at the Problem
We’re being told over and over that “throwing hardware at the problem” is not the correct solution for performance problems...
2015-02-24 (first published: 2015-02-12)
8,153 reads
Presentation slides for “Building a Big Data Solution”
Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop,...
2015-02-24
983 reads
Speaking at SQLBits and SQLRally
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and...
2015-02-24
458 reads
SQL Cruise Caribbean 2015 Recap
UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....
2015-02-24
1,133 reads
Automating SSAS Backups
Backing up databases is one of the most important jobs of a DBA. If your data is not safe, your...
2015-02-23 (first published: 2015-02-11)
9,073 reads
Book Review: Virtualizing SQL Server with VMware
It’s not often that you’ll see me write a lengthy book review. Most book reviews are fluff telling you to...
2015-02-23
1,378 reads
Join me for Dashboards in a Day
Seats are limited – act fast!
This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA...
2015-02-23
1,253 reads
Missing Full Text Extensions in Express
I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were...
2015-02-23
990 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