Oh Yes It’s Ladies Ni…errr…Month
Making WIT awesome since 1993
It’s March and this month sees a lot of celebration, amongst the parties are Mardi Gras...
2011-03-04
444 reads
sqlchicken
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
699 reads
BIxPress 3.0: DBAs Welcome!
Much like the USA Network here in the States welcomes characters, I’d like to formally let the world know that...
2011-02-14
578 reads
SQL University: State of the Union
The new SQL University Logo
Well the new year is here and SQL University is back and better than ever! I...
2011-02-03
650 reads
Temporary Post Used For Theme Detection (da60724d-7ccd-4e8d-906c-51c74980afa7 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (983091ab-b664-45c1-9b17-9e54b839020e – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
Digg This PostStumble This Post
2011-01-25
425 reads
Policy for Ad-hoc Workloads
During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check...
2011-01-20
926 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-18
1,258 reads
EPM Framework and SQL 2008 R2
This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...
2011-01-17
1,319 reads
SQL University: Spring 2011
The new SQL University Logo
Welcome back students! We’re very excited to start up a new semester and SQLU is back and...
2011-01-13
853 reads
Pragmatic Works: The Transition
So if you know me via Twitter or my blog you
probably know that as of about a month or two...
2010-12-21
995 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
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...
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