SQL Server Virtual File Stats
Easily view the cumulative I/O stats for each SQL Server database file.
Created: 8/17/2013
Enable or Disable Schema Replication
A straight forward approach to enabling of disabling the automatic replication of schema changes in transactional replication.
Created: 2/10/2013
Page Splits per-Second Over Time
A script to get you on the easy road to page-split baselining.
Created: 2/9/2013
Alter the Fill Factor on all GUID Columns
Easily decrease the fill factors on all of those uniqueidentifier/GUID columns.
Created: 2/9/2013
Finding Duplicate SQL Statistics
A quick and efficient view to find duplicate statistics on your SQL Server tables.
Created: 2/9/2013
Finding Duplicate SQL Indexes
A quick and efficient view to find duplicate indexes on your SQL Server tables.
Created: 2/9/2013
Get Table Row Counts
A script to quickly retrieve the count of rows from all tables in a database.
Created: 2/9/2013
Read File as Table
Allows you to easily select from a file on the file system as if it were a table.
Created: 2/9/2013
Split Array
SplitArray is a powerful table SQL function which splits delimited values into a row-set.
Created: 2/9/2013
Get First and Last day of Month
Two simple functions to get the first and last day of a month.
Created: 2/9/2013
Format Currency
Easy currency formatting of numbers in SQL Server using a scalar function.
Created: 2/9/2013
Format Number and Decimal Value
Easy formatting of numbers in SQL Server using a scalar function.
Created: 2/9/2013
String and Numeric Padding
SQL functions used to left and right pad a values with 0s (or some other value),
Created: 2/9/2013
Delete Unused Agent Schedules
Ever stepped back and looked at the enourmous barrage of unused SQL Agent Schedules? Clean them up!
Created: 2/8/2013
Proper Name Casing in SQL Server
Need to format a name for a form? Well, this isn't perfect by any means, but it's a start.
Created: 2/8/2013
Microsoft's ListView, What is it good for?
Microsoft's ListView... What is it good for?! Well, I've got a few ideas...
Created: 2/8/2013