Favorite Articles-3

SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison
SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup
SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2

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 – Introduction and Explanation to sqlcmd
SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
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

Comments are closed.