2008-10-01
2,138 reads
Full-Text Search (2008)
2008-09-02
2,616 reads
Featured Blog: iFTS Performance – DocidMap
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
2008-03-06
1,574 reads
Featured Blog: iFTS Manageability – Loading thesaurus files
MVP Simon Sabin continues his in depth look at Full Text Search in SQL Server 2008. This time he examines how you can load Thesaurus files.
2008-03-04
1,883 reads
Featured Blog: iFTS Transparency – Viewing the words in the index
This next post on Full Text search from MVP Simon Sabin examines how you can examine the details of what your indexes contain.
2008-02-28
1,620 reads
Featured Blog: iFTS Transparency – dm_fts_parser
In this post on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser.
2008-02-26
1,987 reads
Featured Blog: SQL Server 2008 – iFTS Introduction
This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008 from MVP Simon Sabin. We'll continue this series on with an in depth look at this feature.
2008-02-25
2,626 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