Favorite Articles-1

SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
SQL SERVER – Indexed View always Use Index on Table
SQL SERVER – The Limitations of the Views – Eleven and more…
SQLAuthority News – What is an MVP? – How to become an MVP?
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion

SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
SQL SERVER – Best Practices for DBA Before Taking Vacation
SQL SERVER – Computed Column – PERSISTED and Storage
SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats
SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache
SQL SERVER – Convert IN to EXISTS – Performance Talk
SQL SERVER – Stored Procedure and Transactions
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
SQL SERVER – GUID vs INT – Your Opinion
SQL SERVER – Enumerations in Relational Database – Best Practice

SQL SERVER – Rollback TRUNCATE Command in Transaction
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate
SQL SERVER – Execution Plan – Estimated I/O Cost – Estimated CPU Cost – No Unit
SQL SERVER – Difference Between Candidate Keys and Primary Key
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

Comments are closed.