Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali
I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL...
2011-04-05
605 reads
Blog Posts
Am I a sysadmin? (or other SQL Server role)
How do you check if you are a sysadmin? It’s fairly easy to do in Management Studio. You can go...
2011-04-05
24,193 reads
Canada Begins Return to Democracy as the ‘Harper Government’ Found in Contempt of Parliament, a First Throughout the Commonwealth – And No Confidence Vote Triggers the Election Race
For over a week now, Canada has begun its return to appearing to be a democracy thanks to a Liberal...
2011-04-05
1,221 reads
Epsilon Data Breach and Staying Safe
By now, you may have received an email from one of the larger businesses you've given your email address to...
2011-04-05
767 reads
How to Deal with Quebec’s Extremists – Report their Threats to the Police (Investigation Under Way)
I’m part of a Committee that is dedicated to eliminating discriminatory legislation in Quebec, here’s a statement we released last...
2011-04-05
2,426 reads
Powershell Day 5
Day 5 Programming in Powershell Part 3 Now as you know all information, in this blog we will look for...
2011-04-05
347 reads
Rant About Judges that Misunderstand the Role of a DBA
Part - 07 Exerpts from "The Tyranny of Bill-101" - Part 07
Commenting on how frustrating it is for DBAs to deal with...
2011-04-05
684 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The meeting is to be held April 14, 2011 at...
2011-04-05
6 reads
S3OLV April 2011
Are you ready to learn again? The Las Vegas SQL Users Group is ready to have our April meeting. The...
2011-04-05
543 reads
Should a DBA be involved in the physical set up of a Database server? Part1
There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server....
2011-04-05
1,639 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