A set based T-SQL Solution for Sudoku Puzzle
A set based T-SQL solution for Sudoku puzzle. This is an update to my previous post with some corrections and in-line comments.
2009-07-29 (first published: 2009-07-14)
1,334 reads
Scripts
Get DDL for any SQL 2000 table
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.
2009-07-28 (first published: 2009-07-11)
837 reads
Updating Datbase Mail Exchange Server
Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one
2009-07-27 (first published: 2009-07-08)
514 reads
2009-07-23 (first published: 2009-07-13)
1,412 reads
Sybase linked server in sql 2005
How to create and configure Sybase linked server in SQL Server 2005
2009-07-21 (first published: 2009-07-09)
678 reads
Find SQL Server Authentication Mode Configuration
Quick Method to find Configured???????????????????????? Authentication Mode
2009-07-20 (first published: 2009-07-07)
921 reads
2009-07-17 (first published: 2009-07-08)
924 reads
Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)
Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.
2009-07-15 (first published: 2009-07-03)
1,330 reads
Three Sample reports for the Automated DBA: Space Usage SnapShotter
1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot
2009-07-13 (first published: 2009-07-03)
2,486 reads
Get DDL for any SQL 2005 table
returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.
2009-07-11
1,895 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Alamat BCA KCU Pantai Indah Kapuk Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Pantai Indah Kapuk Utara I Blok F, RT.6/RW.2, Kamal...
Alamat Kantor BCA KCU Taman Duta Mas Tlp:0817825533
Hub Via Wa:62817825533 Alamat: ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, RT.14/RW.11,...
Alamat Kantor BCA KCU Tanjung Priok Tlp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. Enggano No.22-23, RT.8/RW.16, Tj. Priok, Kec. Tj. Priok, Jkt...
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers