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 Management Studio
No comments:
Post a Comment
All suggestions are welcome