SQLServerCentral.com Content tagged SQLInsider Scriptshttp://www.sqlservercentral.com/Content tagged SQLInsider Scripts posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol setFeed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Delimited String Parsing Functions - Big2D setFeed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/Delimited String Parsing Functions - Basic SetFeed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Delimited String Parsing Functions - 2D setFeed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/Delimited String Parsing Functions - Big SetFeed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/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/Generate Job Schedule DescriptionsA SELECT statement which includes the alpha description of each job's schedulehttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/2008/01/07http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/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/Server Up-Time Informationhttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31994/2007/11/15http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31994/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/A Simply way to implement Audit Trail in SQL 2005http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/32008/2007/09/20http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/32008/LSTR() and RSTR(): Enhanced LEFT() and RIGHT()http://www.sqlservercentral.com/scripts/Miscellaneous/32002/2007/09/13http://www.sqlservercentral.com/scripts/Miscellaneous/32002/Verify Errorloghttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/2007/09/12http://www.sqlservercentral.com/scripts/T-SQL+Aids/31925/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/Script SQL Server DDLhttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/2007/08/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/31869/Way to Delete duplicate rows in a table.http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31842/2007/08/07http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31842/Finding other database objects referenced in an SPhttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31836/2007/07/31http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31836/Show Line of Code Executing in Procedurehttp://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31818/2007/07/18http://www.sqlservercentral.com/scripts/SQLInsider+Scripts/31818/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/An old and new way to query Hierarchical datahttp://www.sqlservercentral.com/scripts/T-SQL+Aids/31065/2007/05/02http://www.sqlservercentral.com/scripts/T-SQL+Aids/31065/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 Primary Keyshttp://www.sqlservercentral.com/scripts/Index+Management/31892/2007/03/28http://www.sqlservercentral.com/scripts/Index+Management/31892/