• Favorite Scripts ||
• All Scripts - 1 ||
• All Scripts - 2

SQL SERVER - Simple Example of Reading XML File Using T-SQL
SQL SERVER - Simple Example of Creating XML File Using T-SQL
SQL SERVER - Quickest Way to - Kill All Threads - Kill All User Session - Kill All Processes
SQL SERVER - 2008 - 2005 - Rebuild Every Index of All Tables of Database - Rebuild Index with FillFactor
SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL - Part 2
SQL SERVER - Find Currently Running Query - T-SQL

SQL SERVER - How to Rename a Column Name or Table Name
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case - Part 2
SQL SERVER - Get Date Time in Any Format - UDF - User Defined Functions
SQL SERVER - 2000 - SQL SERVER - Delete Duplicate Records - Rows - Readers Contribution
SQL SERVER - Find Nth Highest Salary of Employee - Query to Retrieve the Nth Maximum value
SQL SERVER - 2005 - Find Nth Highest Record from Database Table - Using Ranking Function ROW_NUMBER
SQL SERVER - 2005 - A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
SQL SERVER - Three T-SQL Script to Create Primary Keys on Table

SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text
SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
SQL SERVER - Count Duplicate Records - Rows
SQL SERVER - 2005 - List All Stored Procedure Modified in Last N Days
SQL SERVER - 2005 - UDF - User Defined Function to Strip HTML - Parse HTML - No Regular Expression
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice
SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
SQL SERVER - Query to Find First and Last Day of Current Month
SQL SERVER - UDF - Function to Convert List to Table
SQL SERVER - Creating Comma Separate Values List from Table - UDF - SP

SQL SERVER - Random Number Generator Script - SQL Query
SQL SERVER - TRIM() Function - UDF TRIM()
SQL SERVER - Query to Find Seed Values, Increment Values and Current Identity Column value of the table
SQL SERVER - UDF - User Defined Function to Extract Only Numbers From String
SQL SERVER - Query to find number Rows, Columns, ByteSize for each table in the current database - Find Biggest Table in Database