Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
6 reads
Blog Posts
Are You Willing To Relocate?
I've recently been talking to people looking for DBAs and one of the questions that always gets asked early on...
2011-08-31
2,724 reads
BI Battle Royale–Adam beats up a Hippie
Weekday Lunch RAW!
Welcome to the Smack-down ladies and gentleman. I couldn?t believe it when Brian walked into my office the...
2011-08-31
1,800 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,808 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is...
2011-08-31
11 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,419 reads
Check the Default Database Setting for your Admin Accounts
Last weekend, as I was waiting for the start of the performance of the Cleveland Orchestra at its summer outdoor...
2011-08-31
1,800 reads
Convert EBCDIC to ASCII in SSIS
Converting EBCDIC to ASCII in SSIS 2008 can seem like a daunting task. There is a lot of manual work...
2011-08-31
8,727 reads
Mobile Commerce and SQL Performance Tuning
I was reading through Gartners Top Predictions and one prediction captured my attention:
“By 2014, over 3 billion of the world's...
2011-08-31
1,738 reads
Presenting at Curacao SQL UG
On Thursday, Sept 1, 2011 at 7:15pm EST, I’ll be presenting via LiveMeeting to the Curacao SQL Server User Group....
2011-08-31
1,667 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