Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
318 reads
Blog Posts
The SSMS Super Clipboard (Day 13)
We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it...
2018-01-13
398 reads
tsqlt Tests for Advent of Code 2017 Day 2
This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-13
887 reads
Changing Case (Day 12)
In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However,...
2018-01-12
290 reads
Creating a SQL Server Test Lab On Your Workstation – Part Two, Creating a Domain Account and Joining a SQL Server to the Domain
In the second part of our series on creating a SQL Server test lab on your workstation, I’m going to...
2018-01-12 (first published: 2018-01-03)
2,334 reads
Friday Reading 2018-01-11
Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have...
2018-01-12
316 reads
My Tech Reading List to Start the Year
My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...
2018-01-12 (first published: 2018-01-02)
1,805 reads
Block Select/Replace (Day 11)
While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that...
2018-01-11
241 reads
Changing the Path for the Master Database
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a...
2018-01-11
356 reads
Changing the Path for the Master Database
Link Below:
Changing the Path for the Master Database
This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving...
2018-01-11
11 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