Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never...
2011-11-16
19 reads
Blog Posts
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The...
2011-11-16
604 reads
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,887 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what I wrote here and here. Since writing those last...
2011-11-15
10 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what...
2011-11-15
849 reads
ColoradoSQL in November (2011)
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-11-15
823 reads
DBA in Space: Behind the Scenes Part 2
This is a continuation of my DBA in Space journal.
Monday & Tuesday, September 12-13, 2011
Today I make my “secret” journey to...
2011-11-15
560 reads
Going to PASS 2012!
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
386 reads
Last Week's DB Security Workshop @ Oracle Montreal
DB Security Workshop @ Oracle Montreal
I have
dedicated several posts on the importance of being a Data Steward, and the
consequences of not...
2011-11-15
1,742 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,062 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