SQLServerCentral.com Content tagged Miscellaneous, SQLInsider Scriptshttp://www.sqlservercentral.com/Content tagged Miscellaneous, SQLInsider Scripts posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Counter Table (table of numbers) Setter-Upper for SQL Server 2005Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/Counter Table (table of numbers) Setter-Upper for SQL Server 2000Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/Find Table Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31553/2007/10/23http://www.sqlservercentral.com/scripts/Miscellaneous/31553/Find Table Usagehttp://www.sqlservercentral.com/scripts/Miscellaneous/31553/2007/10/23http://www.sqlservercentral.com/scripts/Miscellaneous/31553/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Table row count using 3 different wayshttp://www.sqlservercentral.com/scripts/Miscellaneous/31984/2007/08/31http://www.sqlservercentral.com/scripts/Miscellaneous/31984/Delete Duplicates using CTEhttp://www.sqlservercentral.com/scripts/Miscellaneous/31989/2007/08/23http://www.sqlservercentral.com/scripts/Miscellaneous/31989/Make a time value from a given float valuehttp://www.sqlservercentral.com/scripts/Miscellaneous/31804/2007/07/04http://www.sqlservercentral.com/scripts/Miscellaneous/31804/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Function to Split a Delimited String into a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/31913/2007/05/25http://www.sqlservercentral.com/scripts/Miscellaneous/31913/Send SMS from a triggerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31899/2007/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/31899/UDF for date ranges around a given date (updated)http://www.sqlservercentral.com/scripts/Miscellaneous/30864/2007/04/12http://www.sqlservercentral.com/scripts/Miscellaneous/30864/SQL Server 2005: Script all Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31893/2007/03/27http://www.sqlservercentral.com/scripts/Miscellaneous/31893/Script SQL Database DDLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31882/2007/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/31882/Calculating Percentage Changehttp://www.sqlservercentral.com/scripts/Miscellaneous/31868/2007/03/02http://www.sqlservercentral.com/scripts/Miscellaneous/31868/Data Driven Subscriptions in SQL RS Standardhttp://www.sqlservercentral.com/scripts/Miscellaneous/31733/2006/11/13http://www.sqlservercentral.com/scripts/Miscellaneous/31733/MIME64 Encoder and Decoder written in T-SSQLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31751/2006/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31751/Parse a fixed length numeric value from a stringhttp://www.sqlservercentral.com/scripts/Miscellaneous/31748/2006/11/08http://www.sqlservercentral.com/scripts/Miscellaneous/31748/Random Number Generatorhttp://www.sqlservercentral.com/scripts/Miscellaneous/31793/2006/09/15http://www.sqlservercentral.com/scripts/Miscellaneous/31793/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Overcome BCP limitations for output to CSV filehttp://www.sqlservercentral.com/scripts/Miscellaneous/31756/2006/07/03http://www.sqlservercentral.com/scripts/Miscellaneous/31756/Parse a fixed length numeric value from a stringhttp://www.sqlservercentral.com/scripts/Miscellaneous/31748/2006/11/08http://www.sqlservercentral.com/scripts/Miscellaneous/31748/MIME64 Encoder and Decoder written in T-SSQLhttp://www.sqlservercentral.com/scripts/Miscellaneous/31751/2006/11/09http://www.sqlservercentral.com/scripts/Miscellaneous/31751/move all indexes to a secondary file grouphttp://www.sqlservercentral.com/scripts/Miscellaneous/31541/2006/06/19http://www.sqlservercentral.com/scripts/Miscellaneous/31541/move all indexes to a secondary file grouphttp://www.sqlservercentral.com/scripts/Miscellaneous/31541/2006/06/19http://www.sqlservercentral.com/scripts/Miscellaneous/31541/Data Driven Subscriptions in SQL RS Standardhttp://www.sqlservercentral.com/scripts/Miscellaneous/31733/2006/11/13http://www.sqlservercentral.com/scripts/Miscellaneous/31733/Calculate distance between two pointshttp://www.sqlservercentral.com/scripts/Miscellaneous/31679/2006/05/18http://www.sqlservercentral.com/scripts/Miscellaneous/31679/