David Postlethwaite - Exciting news.
By David Postlethwaite
I have been chosen to speak at SQL Saturday in Vienna, Austria on 28th February.
The organisers have just...
2015-01-12
477 reads
Blog Posts
Discussing Security with Boris Hristov on SQLHangout #29
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
535 reads
I’m a SQL Server MVP!
I have been working with SQL Server for the past 17 years, and in the past few years I have...
2015-01-12
642 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
441 reads
Parameterization Part 7: Summary
This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...
2015-01-12 (first published: 2015-01-08)
7,388 reads
She Taught Me to Code–A Tribute to Sheila, My Wife
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2015-01-12
755 reads
SQL Cruise Caribbean Is Coming Soon
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...
2015-01-12
1,249 reads
The big disconnect with Connect
A couple of years ago I blogged about a bug on the Data Collector that I couldn’t resolve but with an...
2015-01-12 (first published: 2015-01-07)
5,299 reads
T-SQL Random Numbers using RAND() for Test Data
T-SQL Random Numbers using RAND()
SQL Server includes the T-SQL RAND() function to create a random value between 0 and 1...
2015-01-12
1,390 reads
2014 Year In Review
As is our want, we must look back over the past year to see what happened. While I normally focus...
2015-01-11
630 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