Your SQL Server database just failed, can you restore the backup?
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,509 reads
“Thou Shall Not Shrink the Database” #TSQL2sDay
This month, Chris Shaw (Blog | @sqlshaw) is leading the charge on the T-SQL Tuesday. This event is basically a blogging...
2012-05-08
1,001 reads
T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics
Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month. It has been a while since I participated and this month...
2012-05-08
818 reads
T-SQL Tuesday #30 - Ethics and the DBA
This latest installment of T-SQL Tuesday #30, is hosted by SQL MVP, Chris Shaw who asks us to write on a...
2012-05-08
1,899 reads
Picking Technical Conference Sessions (#SQLRally Edition)
Conferences are awesome. They are full of people and sessions. Almost…TOO many sessions. How on Earth do you get in...
2012-05-08
1,172 reads
T-SQL Tuesday #30 – Ethics
This month the topic is hosted by Chris Shaw, and his topic is ethics.
The blog party is the second Tuesday...
2012-05-08
1,062 reads
Denali — Day 8: Startup Parameter
Denali – Day 8: Startup Parameter
Startup Parameters means you are providing the parameter to sql server at the start of sql...
2012-05-08
766 reads
Workspace database server was not found
You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It...
2012-05-08
1,104 reads
My Garden Update
It’s been just over two months since I started my small home garden. The initial work to clear the area...
2012-05-08
661 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these, and how do you deal with them in SQL...
2012-05-08
650 reads
Blogs
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...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
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_CustomerEmail
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.CustomerContactAfter I do this, what will I see for the index status? See possible answers