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,...

TSQL Sudoku II

As luck would have it, today I came across this TSQL Challenge.  It just so happens that I had already...

Defining Your Culture

Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...

Disk IO performance and SQLIO

Performance testing  a new disk subsystem  from a SQL Server perspective is one of the fun aspects of DBA work....

Autogrow bug – fixed with Denali

Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...

SQLMCM Training – Day 15

The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...

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...

SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features

sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:

- Compression,
- Partitioning,
- TDE and...

T-SQL to find Fragmented Indexes

Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...

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...