Database

SQL SERVER:

SQL SERVER - Understanding and Using APPLY - I
SQL SERVER - Understanding and Using APPLY - II
SQL SERVER - Loading XML Data
SQL SERVER - JOINS - I
SQL SERVER - JOINS - II
SQL SERVER - JOINS - III
SQL SERVER - Replace Multiple Spaces with One
Introduction to Indexes - Part I
Introduction to Indexes - Part II
Introduction to Indexes - Part III
Introduction to Indexes - Part IV
Introduction to Indexes - Part V
Introduction to Indexes - Part VI
SQL Server - Difference between TRUNCATE and DELETE
SQL Server - Keyboard shortcuts
SQL SERVER – Create and read XML File Using T-SQL
SQL SERVER – Find Currently Running Query – T-SQL
SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using ROW_NUMBER
SQL SERVER – Creating Comma Separate Values List from Table – UDF – SPSQL SERVER – Random Number Generator Script
SQL SERVER 2005 – Search Stored Procedure Text