TSQL Sudoku II
Learn how to solve Sudoku puzzles quickly with a TSQL Script.
Related Posts:
Puzzles and Daily Trivia May 14, 2019
Summiting that Technical Challenge Part II July 6, 2018
Passion, Challenges,...
2011-08-23
10 reads
Blog Posts
TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,085 reads
[Speaking] Lots of Speaking Engagements in September and October
As Adam Machanic said, Fall is the busy season for speaking, and it will be for me. Here's a brief...
2011-08-22
770 reads
Define IOPs for all database servers
Purpose
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations.
He’s asked me...
2011-08-22
2,115 reads
Expert? Ha!
How do you define an expert? My personal definition: An expert is the person that is a chapter ahead of...
2011-08-22
1,246 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
950 reads
Networking Dinner at the PASS Summit 2011
We’re repeating our event this year, a low key no sponsor dinner for those that arrive early and want to...
2011-08-22
677 reads
Outstanding DBAs Make Relationships a Priority
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,033 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
7 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
684 reads
Blogs
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...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
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_CustomerEmail
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.CustomerContactAfter I do this, what will I see for the index status? See possible answers