Dynamics AX Event Session
Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...
2018-01-10 (first published: 2018-01-03)
1,144 reads
Blog Posts
Fixing logins
I ran into an issue recently where I couldn’t get a Windows login to work with some application software. This...
2018-01-10
440 reads
It’s All in the Name, Index Naming Conventions
Awhile back, if you are on Twitter, you can probably recall my ranting about the 949 indexes I was reviewing....
2018-01-10
1,721 reads
Regular Expressions (Day 10)
Have you ever downloaded a script from an internet site, only to find that there are extra blank lines between...
2018-01-10
458 reads
SCOM: SQL Instance and Databases exclusion
This post is by Chris Gibson
I recently wanted to exclude some temporary SQL databases from being discovered by our SCOM...
2018-01-10
1,368 reads
SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,501 reads
Summiting that Technical Challenge
The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:
Summiting that Technical Challenge Part II...
2018-01-10
5 reads
The cloud is not just someone else’s computer
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...
2018-01-10
371 reads
A Better Way To Script Database Objects
Photo by Andy Beales on Unsplash
Happy New Year! My New Year’s resolution for 2018 is to help you become a...
2018-01-09 (first published: 2018-01-02)
3,711 reads
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...
2018-01-09
307 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