2011-08-24
28 reads
Blog Posts
Replication Agent Logging
To troubleshoot replication agent failures, replication agent profiles can be configured to output verbose agent logs to a text file. ...
2011-08-24
4,426 reads
Season of Satan - Earthquake, Hurricanes, Jitters & Twitter
I read Andy Leonard's Blog on Earthquakes and Technology, who thought a helicopter was landing in his back yard (LOL), and inspired...
2011-08-24
1,193 reads
SQL Server – sp_help without arguments.
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...
2011-08-24
2,503 reads
SQLMCM Training – Day 16
Today Bob spoke the whole day about securing SQL Server, security itself, and encrypting
data. It was really hard content, and...
2011-08-24
637 reads
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I...
2011-08-24
1,850 reads
What I’ve Been Up To Lately
I ran into a friend at a recent event and during the discussion he asked what I was doing lately...
2011-08-24
641 reads
A Couple of Data Compression Tricks in SQL Server 2008
As I have said several times before, I am a big fan of data compression in SQL Server 2008 and...
2011-08-23
1,930 reads
Autogrow bug – fixed with Denali
Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...
2011-08-23
1,876 reads
Computed Columns and CASE
I wrote about computed columns recently, but I didn’t realize that a logical expression could be used here, such as...
2011-08-23
28,985 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