Is Your Database Overweight?
The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...
2017-12-27 (first published: 2017-12-13)
1,769 reads
Blog Posts
Message in a Bottle of XE
Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
5 reads
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
934 reads
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
183 reads
No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard...
2017-12-27
372 reads
Power BI Custom Visuals Class (Module 83 – ChartAccent – LineChart)
In this module you will learn how to use the ChartAccent LineChart Custom Visual. This visual is a custom line...
2017-12-27
1,255 reads
Precon at SQLKonferenz 2018
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz,...
2017-12-27
356 reads
Renaming a Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27 (first published: 2017-12-11)
2,023 reads
Restoring a Copy Only Backup–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27
745 reads
The case of the missing database backup file
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
569 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
ALAMAT BCA KCU TEGAL Tlp:08218154374
Hub Via Wa 628218154374 Alamat Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim.,...
ALAMAT BCA KCU SALATIGA Tlp:08217555651
Hub Via Wa 628217555651 Alamat Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo,...
ALAMAT BCA KCU PEKALONGAN Tlp:0817825533
Hub Via Wa:62817825533 Alamat Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa...
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