Physical File Defragmentation
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
2009-05-01
554 reads
Editorials
Mistakes in April
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
2009-04-30
121 reads
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
2009-04-29
123 reads
The Best High Availability
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
2009-04-28
718 reads
All-Access
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-27
108 reads
Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
2009-04-27
115 reads
Manage Your Career
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-22
430 reads
Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-21
109 reads
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-20
89 reads
Lassoing a Cloud
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
2009-04-17
249 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