Conversations with Data Warehouse Experts – Podcast
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
510 reads
Blog Posts
Conversations with Data Warehouse Experts – Podcast
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
58 reads
I’m Speaking At SQL Saturday Richmond
I am so excited, I was selected to speak at SQL Saturday Richmond on March 24, 2018, in Richmond, Virginia.
SQL...
2018-02-06
266 reads
Information Measurement with SQL Server, Part 2.5: Mutual, Lautum and Shared Information
By Steve Bolton
…………The sample T-SQL I posted in the last article wasn’t as difficult as it looked, considering that it...
2018-02-06 (first published: 2018-01-25)
1,154 reads
Lessons Learned From SQL Saturday Cleveland
I can finally breath a sigh of relief, my first time of presenting two sessions back to back is finally...
2018-02-06
254 reads
Power BI Data Security – Sharing
Microsoft recently added more sharing capabilities that may change my view on sharing within the enterprise. As with all things...
2018-02-06 (first published: 2018-01-29)
1,647 reads
Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
422 reads
SQL Server – Internals of sp_spaceused
This article is an effort to dissect the output of the sp_spaceused stored procedure.
Introduction
Understanding the database usage internals and the growth trends...
2018-02-06
465 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
294 reads
tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
241 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