Leo

I started in database administration on mainframes in 1995 after in house training with a bank in South Africa. Picked up MS SQL Server from 1998 with SQL 6.5. From there I've used and migrated databases to every release of SQL Server up to the current release.
Moved to New Zealand in 2006 to work with another bank for 3 years, them got a Senior Consultant position with SQL Services Ltd in 2009 where I worked for 11 years. I've now been with DataSentinel Limited, also a SQL Managed Service provider, also a Senior Consultant since 2020.
I've been a contributor to SQL Server Central since about 2004. In New Zealand I have presented at local user group meetings and TechEd, and consulted on behalf of Microsoft in Australia.
I consider some of my strengths to be: The ability to see the root cause of a problem based on minimal information, often identifying solutions that have not occurred to others. Doing research and testing to find root causes and solutions, and being able to communicate DBA principles at all levels, including to non-technical stake holders.

All authors

It seems we can’t find what you’re looking for. Perhaps searching can help.

Read the latest Blogs

Visit the forum

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 disable

I see this when I check the index status: Index status for CustomerContact

I decide to rebuild all indexes with this command:

ALTER INDEX ALL ON dbo.CustomerContact rebuild

After I do this, what will I see for the index status?

See possible answers

Leo

Blogs

When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?

Accessing the Data API Builder MCP Server from VS Code

From DBA or Data Engineer to AI Engineer: A Realistic Path

Forums

Two queries work until compared with EXCEPT statement

STRING_AGG DISTINCT

In-place OS upgrade or migration to new OS?

Question of the Day

Rebuilding All Indexes