Tactics to Find Outdated Statistics in SQL Server
Statistics in SQL Server are used to identify the type of plan that needs to be executed for a query....
2018-05-21
2,114 reads
What are the system databases?
I get to help with technical interviews every now and again, and one of the questions we always ask is...
2018-05-21
517 reads
Day 20 Innodb Storage engine
InnoDB is the major Storage engine and is default Storage engine after MySQL 5.5 version. As standard RDBMS requires ACID...
2018-05-21
211 reads
SQL Server Stress Testing Using OStress – RML Utilities
As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...
2018-05-28 (first published: 2018-05-21)
7,252 reads
Power BI with Maps: Choose Your Destination
(2018-May-20) A childhood dream to travel around the world fueled by reading Gulliver's Travels stories and Robinson Crusoe attempts to survive on a...
2018-05-29 (first published: 2018-05-20)
4,766 reads
SQL Server Error Handling In Depth
TRY/CATCH RAISERROR Pre SQL Server 2012
Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors. If...
2018-05-20
130 reads
SQL Server Error Handling In Depth
TRY/CATCH RAISERROR Pre SQL Server 2012 Since SQL Server 2005 we’ve had TRY CATCH syntax in SQL Server handle errors....
2018-05-20
101 reads
Thanks for joining us at SQLSat Dallas!
Engaged crowds and great questions at both my morning sessions on Saturday morning at SQLSat Dallas, an event put together by a team of expert SQLSat organizers, including SQL...
2018-05-20
14 reads
C# – Read emails from exchange online mailbox (Office 365) into SQL Server
You have an Office 365 mailbox. You want to use C# to read those mails and save them to SQLServer.
The...
2018-05-20
1,774 reads
SQL Server Triggers and Transactions
In this post I’m going to detail with examples how triggers behave with transactions…
How Do Triggers Behave With Transactions?
To demo...
2018-05-19
145 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