Firefox and Reporting Services
Not everyone uses IE and that’s ok, but what’s strange is that by default if you point Firefox at a...
2011-03-08
863 reads
Blog Posts
Full backups, the log chain and the COPY_ONLY option.
There have been a large number of posts made regarding the interaction between full database backups and the log chain...
2011-03-08
1,345 reads
How to Raise Your Game by Doing Nothing
What if I told you that you could become a more effective Database Administrator by doing nothing?
That’s right, in this...
2011-03-08
488 reads
March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries
Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL...
2011-03-08
652 reads
Speaking at Orlando Code Camp on March 26, 2011
I’ll be speaking at the upcoming Orlando Code Camp on March 26, 2011, at Seminole State College in Lake Mary....
2011-03-08
1,222 reads
SQLSaturday #77 in Pensacola–Call for Speakers
Karla Landrum just announced SQLSaturday #77, coming to Pensacola on June 4, 2011. Pensacola is a great weekend destination, hit...
2011-03-08
864 reads
SQLSaturday#69 - Philadelphia Wrap-Up
Just wanted to take the opportunity to summarize my experience at SQLSaturday#69 in Philadelphia, this past Saturday. Another city, another amazing event! I haven't been...
2011-03-08
2,376 reads
SSRS – Creating and Using Shared Schedules Part 4
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-08
2,211 reads
T-SQL Tuesday #016: Aggregates and Statistics
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
680 reads
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
9 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