Surface: Standard Onscreen Keyboard
If you feel that the default on-screen keyboard on the Surface RT isn't sufficient, you can enable what I would...
2012-11-19
1,261 reads
SQL in the City - New York 2012
I was able to attend the SQL in the City event in New York this past Friday. I highly recommend...
2012-10-01
721 reads
PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it
I recently had the need to script the execution of a command-line utility and thought it would be a good...
2012-08-29 (first published: 2012-08-28)
28,573 reads
Fix: Crystal Reports Shows Red X Across Entire Page When Report Run Inside Visual Studio
I was googling (with Bing AND Google) like crazy for a solution to this, but didn't find one from any...
2012-08-14
2,044 reads
Enabling "Open Project Folder" for project types that don't support it
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...
2012-07-18
756 reads
A Pattern for PIVOT
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of...
2012-07-08
2,056 reads
Excellent SSIS 2012 Upgrade Video
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,312 reads
Another Way To Insert Many Rows Very Fast From Your .NET Application
There was a great deal of feedback to my previous post One Way To Insert Many Rows Very Fast From...
2012-05-15
3,615 reads
One Way To Insert Many Rows Very Fast From Your .NET Application
This is my attempt to explain something that I have wanted to figure out for a long time. I have...
2012-05-15 (first published: 2012-05-11)
71,118 reads
One Way to Work Around the .NET Setup Project’s Picky Version Number Behavior
If you don’t change the version number of your .NET project output every time you create a setup package, you...
2012-05-10
1,745 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