Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)
Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...
2011-10-01
497 reads
Blog Posts
October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?
When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...
2011-10-01
1,093 reads
SQL Saturday 97 starts in 7 hours
I flew into Austin Texas today and got to spend time with a lot of great people. The journey started...
2011-10-01
526 reads
A Good Time to Be a SQL Server Professional
Wow! Can't believe today is the last day of September! Fall, here we come! Although Summer is over, Autumn is...
2011-09-30
1,982 reads
Creating your first Data Mining Structure and Model
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms...
2011-09-30
8,702 reads
Free SQL Server in the City Event to be Held in LA
Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles,...
2011-09-30
1,413 reads
How to find a string value in all the string columns of a table/view in SQL Server ?
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...
2011-09-30
6,352 reads
Join the Wolf Pack at PASS Summit 2011
Quick update for all of you!
Hey there everyone! We are going to have some awesome surprises, new software features...
2011-09-30
1,564 reads
Microsoft SQL Server Reference Architecture and Appliances
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and...
2011-09-30
3,776 reads
New website, exciting future for BRSSUG
Just wanted to push out an announcement that the Baton Rouge SQL Server User Group has a new website.
www.brssug.org
We've...
2011-09-30
1,502 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