Junior DBAs - Where to start?
I personally would start with your local user groups. Getting to know people and networking may be your best bet...
2013-12-06
428 reads
DBA On The Go
Blocked processes: Quick Tips
Sometimes activity monitor just isn't fast enough. Maybe it's not telling you what a specific query is doing. Below is...
2013-12-05
468 reads
Ideal Working Conditions and Free Training Winner!
Contest Winner!
So last Monday I announced a giveaway that I think is a great gift to give away. Every Monday...
2013-12-04
588 reads
Testing labs
What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost...
2013-12-13 (first published: 2013-12-03)
1,265 reads
Index Rebuild Status Update And Giveaway!: Quick Tips
I have a Free 1-Month code to PluralSight. There's no catch or gimmick, If your comment is in this post,...
2013-12-02
493 reads
Free Friday: Training
There are a number of good sites that offer free training and free E-Books. The community around MS SQL is...
2013-11-29
1,191 reads
Decrypting Stored Procedures Thanksgiving Special:Quick Tips
Update: Thanks for your response Jon Gurgul! I have updated the files to reflect your updates. It's faster and cleaner...
2013-12-06 (first published: 2013-11-28)
3,488 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,579 reads
Things I've Learned In Regards To Fill Factor:Quick Tips
I don't have much today... It's been a good week so far. I think I'm becoming a bit obsessed with...
2013-11-26
635 reads
Usage grouped by Database: Quick Tips
Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.
select db.name...
2013-11-25
8,903 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