SQL Server: What I Have Learned in January 2011

Dedicated to Visakh Murukes, A Real Technology Evangelist

SQL Server Basics

• How to Create Different Type of Tables
• Table Variables Are Created In Memory Or In Tempdb
• Quickest Way to Create Tables Relationship

 Index Maintenance 

• How to Determine All Indexes Fragmentation
• Simple Method to Resolve All Indexes Fragmentation
• 4 Possible Methods to Resolve Index Fragmentation

 Database Management

• How to Figure out Peak/Off-Peak Hours of Production Databases

Performance Tuning

• Why We Should Avoid COUNT (*)
• 9 Most Forbidden Things
• Which is More Important for Query Optimization, CPU or Logical Reads?
• Performance: Filtered Index a beauty of Sql Server 2008
• Outdated Statistics Can Mislead Query Optimizer
• Bookmark Lookups, a Query Performance Killer

 T-Sql Tips & Tricks

• UNION ALL or UNION
• How to Get Physical Path of Tables and Indexes
• How to Insert Stored Procedure Result Set in a Table
• Function Based Check Constraint
• 3 Methods to Handle NULL for String Concatenation
• Which is the Best Way to Generate Random Number
• ROW_NUMBER () vs. DENSE_RANK ()

 Database Backup & Recovery

• Point in Time Database Recovery