Presenting Tips
Having done a number of presentations, I have accumulated a list of items to go over before each presentation to...
2012-06-06
1,160 reads
Just another SQL blog
I started out as a software developer back in 1996 in Denver, CO, doing Client/Server development in PowerBuilder. The internet...
2012-06-06
597 reads
On Break
I’m at Orlando International as I write this, about to fly to Parsippany for meetings today and tomorrow, then back...
2012-06-06
631 reads
Do You Document Your SQL Server Instances?
When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...
2012-06-12 (first published: 2012-06-05)
4,754 reads
Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...
2012-06-11 (first published: 2012-06-05)
5,435 reads
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
943 reads
New SSIS 2012 Expressions
SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.
LEFT
The LEFT...
2012-06-05
2,392 reads
Download: Consolidated Denali a Day – May 2012
Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for...
2012-06-05
941 reads
Sorry, Mikko, the box was already open
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,395 reads
Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
319 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