Clearing Job Notifications - HELP!
I have inherited a SQL 2005 server with SQL Agent job notifications in place, and a request to clear the...
2012-03-02
908 reads
PepsiCo Women’s Inspiration Award Winner – If I can do it, so can you…
An inspiring story. A hard one, and one that comes from someone with talent.
I like seeing stories like this, and...
2012-03-02
1,015 reads
Introducing SQL Roundup
Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll...
2012-03-02
987 reads
MDX SSRS Parameter Values
<rant> One of the most frustrating things about working with the Microsoft BI Stack is after you go through all...
2012-03-02
9,338 reads
Smart Car Charging
I don’t know if electric cars are the answer, but I do think electricity will play a larger part of...
2012-03-01
887 reads
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,031 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means...
2012-03-01
11 reads
Linked Servers
Do you have linked servers that have been created in your environment? Do you know what these linked servers are?
Finding...
2012-03-01
1,105 reads
Choosing the Right Microsoft Reporting Technology Part 1: Report Services
As Business Intelligence has evolved over the years the number of tools we have to choose from for presenting data...
2012-03-01
1,462 reads
sql server scripts and managing databases
Managing a large SQL Server inventory requires an efficient management processes.
Following on from DBA productivity and less is more , this...
2012-03-01
1,299 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