Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
Error 823: IO error OS cannot read the data
Error: 823,...
2011-11-29
14,075 reads
Blog Posts
DBA in Space: Behind the Scenes—Question 7
This is a continuation of my DBA in Space journal.
Episode seven is filmed at the “Animals in Space” exhibit at...
2011-11-29
571 reads
Execution plan warnings–The final chapter
In my previous posts (here and here), I showed examples of some of the execution plan warnings that have been...
2011-11-29
1,850 reads
New string function in SQL Server 2012 – FORMAT()
Formatting numbers in an SSRS report is a common task. For example, you may want to format a number as...
2011-11-29
3,245 reads
Promoted to Master Group By Thomas LaRock
SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had...
2011-11-29
787 reads
Silly issues with SSRS
Recently I was troubleshooting a report issue where in one of the column was empty in the report. I started...
2011-11-29
905 reads
SQL Mag Top 10 Bloggers
I was astounded to see this blog at #4 on the list from the recent SQL Server Magazine Community Choice...
2011-11-29
712 reads
SQL Saturday 99 – Quest Interview
Welcome to the first of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-11-29
514 reads
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error...
2011-11-29
1,746 reads
SQL Server Special Ops
SQL Server 2012 is coming to 12 cities next year. Is your city on the list? It can be – or...
2011-11-29
862 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