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,336 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)
838 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)
515 reads
2009-07-23 (first published: 2009-07-13)
1,413 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)
680 reads
Find SQL Server Authentication Mode Configuration
Quick Method to find Configured???????????????????????? Authentication Mode
2009-07-20 (first published: 2009-07-07)
924 reads
2009-07-17 (first published: 2009-07-08)
925 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,331 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,487 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
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers