Win A Free Registration to SQLskills Immersion Event 1
You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training...
2012-06-29
1,713 reads
Get Dependent Databases, Tables, Columns…
Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...
2012-07-06 (first published: 2012-06-29)
4,172 reads
Using Excel Macro (.xlsm) Enabled Files in SSIS
Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...
2012-07-05 (first published: 2012-06-29)
6,279 reads
Powershell, SMO, and Add-Member - Not Always BFF
Over the past few weeks, I’ve been working with SMO to implement some maintenance routines across my clients. Because of...
2012-07-04 (first published: 2012-06-28)
3,957 reads
Troubleshooting Database Mirroring Error 1418 Updated
Troubleshooting Database Mirroring Error 1418 Updated
Last night I was helping someone with a database mirroring setup problem via email. It...
2012-06-28
3,841 reads
SQL 2000 TIPS AND TRICKS DECK AND DEMOS
Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...
2012-06-28
1,198 reads
Speaker Selection for SQLSaturday Orlando-Group #2
Four more speakers we’re pleased to have joining us at SQLSaturday #151 this fall in Orlando!
Paul Waters
Mike Antonovich
David Liebman
Bradley Schacht
2012-06-28
1,405 reads
Free Training: Performance Tuning with Free Tools!
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...
2012-06-28
1,400 reads
Speaker Selection for SQLSaturday Orlando-Group #1
Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...
2012-06-28
1,554 reads
Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
2,995 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