Readers' Fincest Choice on SQLAuthority.com
SQL SERVER - Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
SQL SERVER - Plan Caching and Schema Change - An Interesting Observation
SQL SERVER - Mirrored Backup and Restore and Split File Backup
SQL SERVER - Introduction to SQL Server 2008 Profiler
SQL SERVER - Introduction to Cloud Computing
SQL SERVER - Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char
SQL SERVER - Interesting Observation of Logon Trigger On All Servers - Solution
SQL SERVER - Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
SQL SERVER - Introduction to JOINs - Basic of JOINs
SQL SERVER - Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
SQL SERVER - 2008 - SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
SQL SERVER - Interesting Observation of ON Clause on LEFT JOIN - How ON Clause Effects Resultset in LEFT JOIN
SQL SERVER - Difference Between Union vs. Union All - Optimal Performance Comparison
SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
SQLAuthority News - Top 10 Tips for Successful Software Outsourcing
SQLAuthority Author Visit - IT Outsourcing to India - Top 10 Reasons Companies Outsource
SQL SERVER - 2005 - Search Stored Procedure Code - Search Stored Procedure Text
SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases - Part 2
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 - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
SQL SERVER - Difference Between Unique Index vs Unique Constraint
SQL SERVER - TRIM() Function - UDF TRIM()
SQL SERVER - CASE Statement/Expression Examples and Explanation
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 - Delete Duplicate Records - Rows
SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
SQL SERVER - Query to find number Rows, Columns, ByteSize for each table in the current database - Find Biggest Table in Database
SQL SERVER - Simple Example of Cursor
SQL SERVER - Shrinking Truncate Log File - Log Full
Community Links
