SQL Server: What I Have Learned In February 2011

Dedicated to Tara Kizer., who is on this planet, just to help others.

February was a tough month as I switched my company and also because of my final term exams. Here is a list of topics which I have learned and shared in February 2011.   

Data Migration

• SQL Server: How to Avoid Data Loss During Migration From MS Excel
• SQL Server: How to Migrate Data From Top Speed Database Files

TSQL Tips and Tricks

• SQL Server: A Simple Method to Get Specific Part of String
• SQL Server: 20 Most Commonly Used DateTime Formats
• SQL Server: How to Transfer All Objects of a Schema
• SQL Server: How to Delete or Update Rows with JOIN Clause
• TSQL Challenge 49: Identify overlapping time sheet entries of field technicians

Performance Tuning

• SQL Server: Indexes for GROUP BY Columns, a Good Choice
• SQL Server: When We Should Use Cross or Outer Apply Instead of Simple Joins
• SQL Server: Mind Your Search Conditions In WHERE Clause
• SQL Server: Data Type DATETIME or Only DATE
• SQL Server Performance: Not All Fast Queries Are Innocent
• SQL Server: When We Should Use Read Only Cursors

Database Design

• SQL Server: Why We Should Prefer Database to Implement Data Integrity

SQL Server Management Studio

• SQL Server: How to Refresh Intellisense Cache