Install SQL Server 2012 Book online on local disk
After installing the SQL Server 2012 on my laptop, I found there is only online document available, no local book...
2012-04-01
25,998 reads
April Question: What’s your favorite DBA book, and why?
Over and over again, I get asked which DBA books I recommend. With this in mind, this month’s qustion is...
2012-04-01
1,113 reads
Slides & Samples for my DevWeek and SQLbits sessions
As I have announced in my DevWeek and SQLbits sessions, you can find my session materials
(slides & samples) here for download:...
2012-04-01
828 reads
Announcing SQLSaturday #175–In Flight Edition
One of the things I like about SQLSaturday is that it’s a place to try new ideas. This year on...
2012-04-01
691 reads
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to...
2012-04-01
3 reads
SQL 2012 has Launched
LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it,...
2012-04-01
989 reads
Monitor SQL Server Backup job duration
if you run BACKUP DATABASE T-SQL, there is a parameter STATS which reports the percentage complete, However when you run the...
2012-03-31
1,921 reads
Reflections on Leaving Microsoft
Reflections on Leaving Microsoft
Reflections of Microsoft By Jeff Sandquist (http://www.flickr.com/photos/jeffsand/)
Several members of my SQLFamily have made adjustments to their career...
2012-03-31
2,304 reads
Thank God I Chose SQL Server part I: The Tribulations of a DB2 Trial
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of...
2012-03-31
3,671 reads
Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,524 reads
Blogs
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
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...
Forums
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
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_CustomerPhone
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.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers