Sql Server: What I Have Learned in December 2010

Dedicated to my inspiration Pinal Dave

 Performance   & Tuning

1.      Which Statement Triggered the Recompile Event

2.      Performance Counter to Count Stored Procedure Re-compilations

3.      Avoid LIKE Operator for Exact Searches

4.      Covering Index, A performance booster for query

5.      Does Your Sql Server Machine Need More RAM? Buffer Cache Hit Ratio Can Inform You.

Sql Server Internals:

1.      Negative Side Effects of Altering Tables

2.      Why We Can't Add New Column in Between Existing Columns

 Sql Server Security

1.      Find and Kill Specific User Session

2.      Hide Database Name from Specific User in SSMS

 Sql Server Integration Services

1.      Merge Join Problem

2.      FILESTREAM Data Export and Import By Using SSIS Package

Sql Server Tips & Tricks

1.      Generate Conditional Table Data Script

2.      Sequence to Create Error Free Objects Script for Whole Database

3.      Compare two strings on basis of how they sound

4.      ORDER BY column name Or ORDER BY column number

5.      Cautions Must Be Taken for WHERE Clause

6.      Common Misconceptions Regarding IDENTITY Columns

7.      Insert Explicit Value for Identity Column in Table

8.      Clean Query Plans and Buffer Pool before Query Performance Comparison

9.      The Magic of GO Command

10.  (Msg 101000) Cannot Create Index on View Because it Contains the DISTINCT Keyword

11.  Table Valued Function