Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.

Using OVER() to Fix Bad Version Numbers

See how the OVER() clause was used in a live system to fix overlapping field version numbers.

SQL 2012: Dirty pages flushed in a single write

Random Lottery Number Generator

This script will generate 5 lottery numbers plus one mega and you can set how many tickets and the range for the numbers for the different types of lotteries.

Brute Force data search tool

searches entire db for a string, number, or date, returns list of results

Get Space on SQL hardrive

I was recently asked to monitor the Database size on the SQL server, and display the results in a report.

Database File Move Etc

A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts

Determine Easter Sunday

Determine what day easter sunday will be based upon the year you pass the function

Who are connecting to database and disconnect ...

When you want gain exclusive access to database in order to restore database

Move database files to another Drive

This script either generates or execute statements to SQL data and log files from C:\ to D:\