• Best Articles ||
• Favorite Articles - 1 ||
• Favorite Articles - 2

SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL - Part 2
SQL SERVER - Difference Between Index Scan and Index Seek
SQL SERVER - Find Currently Running Query - T-SQL
SQL SERVER - 2008 - Certification Path Complete Download PDF
SQL SERVER - Find Table Rowcount Without Using T-SQL and Without Opening Table
SQL SERVER - Clear Drop Down List of Recent Connection From SQL Server Management Studio

SQLAuthority News - Definition - Outsourcing, Offshoring, Nearshoring, Offshore Outsourcing
SQL SERVER - Introduction and Example of UNION and UNION ALL
SQL SERVER - Renaming SP is Not Good Idea - Renaming Stored Procedure Does Not Update sys.procedures
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 - 2008 - Introduction to Merge Statement - One Statement for INSERT, UPDATE, DELETE
SQL SERVER - How to Rename a Column Name or Table Name
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database

SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN - INTERSECT vs. INNER JOIN
SQL SERVER - Effect of Order of Join In Query
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 - 2005 -Track Down Active Transactions Using T-SQL
SQL SERVER - SP_CONFIGURE - Displays or Changes Global Configuration Settings
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 - Difference Between Database Mail and SQLMail

SQL SERVER - 2008 - Introduction to New Feature of Backup Compression
SQL SERVER - 2008 - Insert Multiple Records Using One Insert Statement - Use of Row Constructor
SQL SERVER - Difference Between DBMS and RDBMS
SQL SERVER - Find Current Identity of Table
SQL SERVER - 2008 - Introduction to Policy Management - Enforcing Rules on SQL Server
SQL SERVER - PIVOT and UNPIVOT Table Examples
SQL SERVER - T-SQL Script to Devide One Column into Two Column
SQL SERVER - 2005 - Explanation and Script for Online Index Operations - Create, Rebuild, Drop
SQLAuthority News - Subscribed to SQLAuthority Emails
SQL SERVER - 2005 - Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
SQL SERVER - What is SQL? How to pronounce SQL?
SQL SERVER - One Thing All DBA Must Know
SQL SERVER - Restore Database Without or With Backup - Everything About Restore and Backup
SQL SERVER - 2005 - List All Stored Procedure Modified in Last N Days
SQL SERVER - Definition, Comparison and Difference between HAVING and WHERE Clause
SQL SERVER - Comparison : Similarity and Difference #TempTable vs @TempVariable
SQL SERVER - 2005 Row Overflow Data Explanation
SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
SQL SERVER - 2005 - UDF - User Defined Function to Strip HTML - Parse HTML - No Regular Expression
SQL SERVER - Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
SQL SERVER - 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) - CTE vs. Derived Table
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice
SQL SERVER - 2005 Limiting Result Sets by Using TABLESAMPLE - Examples
SQL SERVER - 2005 TOP Improvements/Enhancements
SQL SERVER - Good, Better and Best Programming Techniques
SQL SERVER - Difference Between Unique Index vs Unique Constraint
SQL SERVER - TRIM() Function - UDF TRIM()
SQL SERVER - 2005 Query Analyzer - Microsoft SQL SERVER Management Studio
SQL SERVER - TempDB is Full. Move TempDB from one drive to another drive.
SQL SERVER - Index Seek Vs. Index Scan (Table Scan)
SQL SERVER - Difference between DISTINCT and GROUP BY - Distinct vs Group By
SQL SERVER - @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT - Retrieve Last Inserted Identity of Record
SQL SERVER - Union vs. Union All - Which is better for performance?
SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case
SQL SERVER - Shrinking Truncate Log File - Log Full