Additional filters:

Baselining Fill Factor Index Performance SQL Agent Strings Currency Formatting Maintenance Rowset SQL Server Tuning Datetime Function Numeric Snippet Statistics View Filesystem GUID Pages

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: 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: 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