2012-07-15
1,146 reads
Introducing Windows Server 2012 – Get the FREE eBook!
Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...
2012-07-14
2,268 reads
SQL Cruise! SQL Saturdays! Summit! SQL-SQL-SQL!
We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the...
2012-07-13
757 reads
Not enough available space on destination..495GB available!
I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...
2012-07-13
1,006 reads
Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,822 reads
SQL Error 18456
18456 is probably one of the most common errors people come across and in this article we try to cover...
2012-07-13
800 reads
Two Socket Database Servers vs. Four Socket Database Servers
Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of...
2012-07-13
1,944 reads
SQL Server: Instant Blocking Alert Using WMI in Your Mailbox
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,754 reads
SQLTreeo is suspended
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
827 reads
I’m Speaking: PASS Summit 2012 and more…
Tuesday, July 10th started a string of speaking engagements I have been blessed (or cursed) with in the months of...
2012-07-12
737 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