On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here...
2012-12-04
12,268 reads
Will Assaf
PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."
Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded. The Managed Add-in Loader failed...
2012-11-30
6,446 reads
Database Design Contest at the 2012 AITP Region 3 Student Conference
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
Performance Tuning Presentation from October 2012 BRSSUG Meeting
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
760 reads
How BETWEEN is inclusive
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,757 reads
SQL Server Best Practices for DMV's - Houston Tech Fest 2012
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
945 reads
SQL Agent Alerts - Severity Condition is NOT "greater than or equal to"
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,276 reads
Actual Emails: The Customer Doesn't Want Full Recovery Mode
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
689 reads
SQL Saturday #150 Baton Rouge 2012
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
784 reads
SQL Server DBA Tool Kit
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,080 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