Presenting at SQLSaturday #107 in Houston in April 2012
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012....
2012-03-31
1,524 reads
Remote DAC connections
TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...
2012-03-31
1,899 reads
Select : Lock or No Lock?
Here is a post I happen to find today: why select command is not blocked by update command?
http://blog.csdn.net/zjcxc/article/details/4383113
First, I...
2012-03-30
3,007 reads
Spring SQL Server Connections / DevConnections
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I...
2012-03-30
2,687 reads
Re-blog – March 23 – March 29
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-03-30
1,875 reads
BIDS Helper 1.6 for SQL Server 2012 released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server...
2012-03-30
2,542 reads
Stress Thoughts-Part 4
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,619 reads
SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition....
2012-03-30
6,874 reads
Liveblog for #SQLBits X Day 1 Keynote
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your...
2012-03-30
1,625 reads
SQL Saturday #130 Jacksonville Schedule Posted
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released...
2012-03-30
1,661 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