A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...

This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.  Read more...

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').  Read more...

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...

The script shows one of ways generating number sequence - this one uses CTE.  Read more...

Just one way of testing for a linked server based on data within your database.  Read more...

Read more...

Three different ways that you can get the count of the rows in a table.  Read more...

Get space for all user defined table information like size and row counts.  Read more...

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...

List permissions for an object in various ways.  Read more...

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...

  At last, my blog is starting to pay real dividends. Not only do I get the opportunity to publish my...  Read more...

Script to find the TCP/IP Port number of SQL Instance  Read more...

Script to find the SQL Server Instance Install Date  Read more...

To see the frequency of alerts in use, you can reset their fire count. Restart count from zero for all alerts using the propre stored procedures.  Read more...

Script to find the SQL Server Instance Install Date  Read more...

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.  Read more...

Script to find the TCP/IP Port number of SQL Instance  Read more...

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