SQLAuthority.com - Frequently Used Scripts
SQL SERVER - Query to find number Rows, Columns, ByteSize for each table in the current database - Find Biggest Table in Database
SQL SERVER - Delete Duplicate Records - Rows
SQL SERVER - UDF - User Defined Function to Extract Only Numbers From String
SQL SERVER - Query to Find Seed Values, Increment Values and Current Identity Column value of the table
SQL SERVER - TRIM() Function - UDF TRIM()
SQL SERVER - Random Number Generator Script - SQL Query
SQL SERVER - UDF - Function to Convert List to Table
SQL SERVER - Creating Comma Separate Values List from Table - UDF - SP
SQL SERVER - Query to Find First and Last Day of Current Month
SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice
SQL SERVER - 2005 - UDF - User Defined Function to Strip HTML - Parse HTML - No Regular Expression
SQL SERVER - 2005 - List All Stored Procedure Modified in Last N Days
SQL SERVER - Count Duplicate Records - Rows
SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text
SQL SERVER - Three T-SQL Script to Create Primary Keys on Table
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
SQL SERVER - How to Retrieve TOP and BOTTOM Rows Together using T-SQL
SQL SERVER - 2005 - A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold
SQL SERVER - 2005 - Find Nth Highest Record from Database Table - Using Ranking Function ROW_NUMBER
SQL SERVER - Find Nth Highest Salary of Employee - Query to Retrieve the Nth Maximum value
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 2008 - Script Bank
SQL SERVER - 2008 - Creating Primary Key, Foreign Key and Default Constraint
SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search
SQL SERVER - 2008 - Introduction to Filtered Index - Improve performance with Filtered Index
SQL SERVER - 2008 - Introduction to Table-Valued Parameters with Example
SQL SERVER - Few Useful DateTime Functions to Find Specific Dates
SQL SERVER - 2008 - Introduction to Merge Statement - One Statement for INSERT, UPDATE, DELETE
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
SQL SERVER - Disable All the Trigger of Current Database
SQL SERVER - EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN - INTERSECT vs. INNER JOIN
SQL SERVER - 2008 - Row Constructors - Load Temp Tables From Stored Procedures
SQL SERVER - 2008 - Get Current System Date Time
SQL SERVER - 2008 - Find Current System Date Time and Time Offset
SQL SERVER - SQL SERVER - Simple Example of Recursive CTE - Part 2 - MAXRECURSION - Prevent CTE Infinite Loop
SQL SERVER - Simple Example of Recursive CTE
SQL SERVER - 2008 - Introduction to SPARSE Columns - Part 2
SQL SERVER - 2008 - Introduction to SPARSE Columns
SQL SERVER - 2008 - Two Convenient Features Inline Assignment - Inline Operations
SQL SERVER - 2008 - Introduction to Row Compression
SQL SERVER - 2008 - Insert Multiple Records Using One Insert Statement - Use of Row Constructor
SQL SERVER - 2008 - Inline Variable Assignment
SQL SERVER - 2008 - Compound Assignment Operators
SQLAuthority.com - Script Bank
SQL SERVER - Query to display Foreign Key relationships and name of the constraint for each table in Database
SQL SERVER - Query to Find ByteSize of All the Tables in Database
SQL SERVER - Auto Generate Script to Delete Deprecated Fields in Current Database
SQL SERVER - Simple Cursor to Select Tables in Database with Static Prefix and Date Created
SQL SERVER - Find Stored Procedure Related to Table in Database - Search in All Stored procedure
SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
SQL SERVER - CASE Statement/Expression Examples and Explanation
SQL SERVER - Query to Retrieve the Nth Maximum value
SQL SERVER - Collate - Case Sensitive SQL Query Search
SQL SERVER - UDF - User Defined Function to Find Weekdays Between Two Dates
SQL SERVER - 2005 - List all the database
SQL SERVER - UDF - Function to Parse AlphaNumeric Characters from String
SQL SERVER - Binary Sequence Generator - Truth Table Generator
SQL SERVER - Disable Index - Enable Index - ALTER Index
SQL SERVER - ASCII to Decimal and Decimal to ASCII
SQL SERVER - Script/Function to Find Last Day of Month
SQL SERVER - 2005 Find Table without Clustered Index - Find Table with no Primary Key
SQL SERVER - UDF - Function to Display Current Week Date and Day - Weekly Calendar
SQL SERVER - LEN and DATALENGTH of NULL Simple Example
SQL SERVER - Find Length of Text Field
SQL SERVER - Explanation and Comparison of NULLIF and ISNULL
SQL SERVER - 2005 List All Tables of Database
SQL SERVER - Running Batch File Using T-SQL - xp_cmdshell bat file
SQL SERVER - Result of EXP (Exponential) to the POWER of PI - Functions Explained
SQL SERVER - 2005 - Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename
SQL SERVER - SPACE Function Example
SQL SERVER - UDF - Get the Day of the Week Function
SQL SERVER - Stop SQL Server Immediately Using T-SQL
SQL SERVER - 2005 - List Tables in Database Without Primary Key
SQL SERVER - 2005 - List All The Column With Specific Data Types
SQL SERVER - 2005 - Find Stored Procedure Create Date and Modified Date
SQL SERVER - Find Last Day of Any Month - Current Previous Next
SQL SERVER - 2005 - Use of Non-deterministic Function in UDF - Find Day Difference Between Any Date and Today
SQL SERVER - 2005 - Find Tables With Primary Key Constraint in Database
SQL SERVER - UDF - User Defined Function - Get Number of Days in Month
SQL SERVER - 2005 - List All The Constraint of Database - Find Primary Key and Foreign Key Constraint in Database
SQL SERVER - Introduction and Example for DATEFORMAT Command
SQL SERVER - 2005 - Explanation of TRY...CATCH and ERROR Handling With RAISEERROR Function
SQL SERVER - T-SQL Script to Add Clustered Primary Key
SQL SERVER - Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
SQL SERVER - 2005 - List All Stored Procedure in Database
SQL SERVER - UDF - Remove Duplicate Chars From String
SQL SERVER - T-SQL Script to Find Details About TempDB
SQL SERVER - Get Information of Index of Tables and Indexed Columns
SQL SERVER - DISTINCT Keyword Usage and Common Discussion
SQL SERVER - Enabling Clustered and Non-Clustered Indexes - Interesting Fact
SQL SERVER - Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
SQL SERVER - 2005 - Last Ran Query - Recently Ran Query
SQL SERVER - 2005 - Introduction and Explanation to SYNONYM - Helpful T-SQL Feature for Developer
SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Datasheet
SQL SERVER - Execute Same Query and Statement Multiple Times Using Command GO
SQL SERVER - 2005 - Display Fragmentation Information of Data and Indexes of Database Table
SQL SERVER - Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE
SQL SERVER - 2005 - Change Compatibility Level - T-SQL Procedure
SQL SERVER - Introduction to Statistical Functions - VAR, STDEVP, STDEV, VARP
SQL SERVER - 2005 - Get a row per file of a database as stored in the master database
SQL SERVER - 2005 - Database Table Partitioning Tutorial - How to Horizontal Partition Database Table
SQL SERVER - Find All The User Defined Functions (UDF) in a Database
SQL SERVER - Simple Example of WHILE Loop with BREAK and CONTINUE
SQL SERVER - 2005 - Find Unused Indexes of Current Database
SQL SERVER - Get Current Database Name
SQL SERVER - UDF to Return a Calendar for Any Date for Any Year
SQL SERVER - Find All The User Defined Functions (UDF) - Part 2.
SQL SERVER - SELECT 1 vs SELECT * - An Interesting Observation
SQL SERVER - Simple Example of Cursor - Sample Cursor Part 2
SQL SERVER - 2005 - Find Nth Highest Record from Database Table
SQL SERVER - 2005 - Retrieve Any User Defined Object Details Using sys.objects Database
SQL SERVER - Add Column With Default Column Constraint to Table
SQL SERVER - 2005 - Find Highest / Most Used Stored Procedure
SQL SERVER - 2005 - Find Index Fragmentation Details - Slow Index Performance
SQL SERVER - 2005 - Introduction to sys.dm_exec_query_optimizer_info
SQL SERVER - 2005 - List All Column With Indentity Key In Specific Database
SQL SERVER - 2005 - Transferring Ownership of a Schema to a User
SQL SERVER - 2005 - Restore Database Using Corrupt Datafiles (.mdf and .ldf) - Part 2
SQL SERVER - 2005 - Find Database Collation Using T-SQL and SSMS - Part 2
SQL SERVER - Generate Foreign Key Scripts For Database
SQL SERVER - Better Performance - LEFT JOIN or NOT IN?
SQL SERVER - Find Table in Every Database of SQL Server Part 2
SQL SERVER - 2005 - Find Tables With Foreign Key Constraint in Database - Part 2
SQL SERVER - Create Default Constraint Over Table Column
SQL SERVER - Create a Comma Delimited List Using SELECT Clause From Table Column
SQL SERVER - Find Current Identity of Table
![[Valid RSS]](http://validator.w3.org/feed/images/valid-rss.png "Validate my RSS feed")