Get Data experience from Excel to Power BI and SQL Server Analysis Services 2017
(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as...
2018-01-20
1,125 reads
Blog Posts
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that will be held on February 3rd at the Francisco...
2018-01-20
6 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
418 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
137 reads
Advent of Code 2017 Day 2–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-19 (first published: 2018-01-11)
1,135 reads
Faster
In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA...
2018-01-19
310 reads
Finding the Default Path with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-19
500 reads
Friday Reading 2018-01-19
It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…
Discussing PASS...
2018-01-19
309 reads
Implementing SSL for Your Blog
With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been...
2018-01-19
526 reads
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...
2018-01-19
136 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