Book: Expert Performance Indexing for SQL Server 2012
After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...
2012-07-10
1,879 reads
SSIS 2012 Change Data Capture (CDC) Control Task
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,122 reads
SQLSaturday #164, Cleveland
Date: August 18, 2012
Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...
2012-07-10
706 reads
SQLSaturday #122, Louisville
Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-07-10
672 reads
SQL Internals Reading Data Records Part 6: Variable Length Data
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,237 reads
Dynamic Multi-Threaded SSIS using C#
Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages. To put it...
2012-07-09
1,471 reads
Moving xml child elements to its parent using XQuery
I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...
2012-07-09
4,542 reads
Purging MSDB Backup and Restore History Tables
Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...
2012-07-09
2,482 reads
Identify and Alert for Long-Running Agent Jobs
Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are...
2012-07-09
11,272 reads
Blueprint for consulting riches
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,529 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