Readers' Fincest Choice on SQLAuthority.com
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
