Additional filters:

Baselining Formatting Keys Primary SQL Agent Strings Currency Function Maintenance Rant SQL Server Stupidity Datetime GUID Numeric Rowset Statistics Tuning Filesystem Index Pages Snippet String View Fill Factor IO Performance

Sort By:

Name Last Updated Ascending Descending

Articles: Alter the Fill Factor on all GUID Columns  Easily decrease the fill factors on all of those uniqueidentifier/GUID columns. Last modified 2/17/2013

Articles: Delete Unused Agent Schedules  Ever stepped back and looked at the enourmous barrage of unused SQL Agent Schedules? Clean them up! Last modified 2/8/2013

Articles: Finding Duplicate SQL Indexes  A quick and efficient view to find duplicate indexes on your SQL Server tables. Last modified 2/17/2013

Articles: Finding Duplicate SQL Statistics  A quick and efficient view to find duplicate statistics on your SQL Server tables. Last modified 2/17/2013

Articles: Format Currency  Easy currency formatting of numbers in SQL Server using a scalar function. Last modified 2/9/2013

Articles: Format Number and Decimal Value  Easy formatting of numbers in SQL Server using a scalar function. Last modified 2/9/2013

Articles: Get Days Of Month  Returns a table with one row per day of a given year and month. Last modified 2/10/2013

Articles: Get First and Last day of Month  Two simple functions to get the first and last day of a month. Last modified 2/9/2013

Articles: Get Table Row Counts  A script to quickly retrieve the count of rows from all tables in a database. Last modified 2/9/2013

Articles: Identifying Page Splits in SQL Server  SQL and SQL only: Identifying Page Splits in a SQL Server Database Last modified 7/31/2015

Articles: Non-unique Primary Keys?  Are primary keys always unique? If not, when? Last modified 4/9/2018

Articles: Page Splits per-Second Over Time  A script to get you on the easy road to page-split baselining. Last modified 2/17/2013

Articles: 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. Last modified 2/8/2013

Articles: Read File as Table  Allows you to easily select from a file on the file system as if it were a table. Last modified 2/17/2013

Articles: Row List  Returns a table with a given number of rows. Last modified 2/9/2013

Articles: Split Array  SplitArray is a powerful table SQL function which splits delimited values into a row-set. Last modified 2/17/2013

Articles: SQL Server Virtual File Stats  Easily view the cumulative I/O stats for each SQL Server database file. Last modified 8/17/2013

Articles: String and Numeric Padding  SQL functions used to left and right pad a values with 0s (or some other value), Last modified 2/9/2013