Lifehacking – Not such a good idea?
I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author...
2012-05-23
1,025 reads
Analyzing TPC-E Benchmark Performance by Physical Processor Core
The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is...
2012-05-23
2,157 reads
Columnstore indexes and memory
Columnstore indexes are built and processed completely in memory. You will receive an out-of-memory error if you do not have enough memory...
2012-05-23
1,464 reads
Watson Plays Jeopardy
I watched the documentary on Nova about the IBM project to build Watson, a computer that could play Jeopardy. The...
2012-05-23
843 reads
Denali – Day 23: Data Quality Services (DQS)
Denali – Day 23: Data Quality Services(DQS)
Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...
2012-05-23
1,473 reads
Plan cache in SQL Server 2008R2
I was curious to look at the effect of database options, on the SQL server plan cache.
I have restored the...
2012-05-23
1,177 reads
How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?
One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...
2012-05-23
60 reads
Marketing Ideas for Chapters & SQLSaturday
I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...
2012-05-23
728 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-22
27 reads
The Tally Table and Expanding Rows
Suppose you had some data like this:
Class Limit
————— ———–
Calculus 5
History 4
Physics 2
But what you really want is this:
Class ...
2012-05-22
1,470 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