Category Archives: SQL server

Parameter Sniffing trace flag 4136

Microsoft has released Cumulative Update Package 7 for SQL2008 SP1 (KB797065). In this update there is a new feature (trace flag 4136) that let us control the Query Optimizer should do parameter sniffing (KB980653) or NOT.   Improve Performance on … Continue reading

Posted in SQL server | 11 Comments

Very Large Database (VLDB) Resources and FAQ

Scalability and Very Large Database (VLDB) Resources   SQL Server Scalability FAQ   Best practices for Microsoft SQL Server 2005 on HP Integrity Superdome servers for Very Large Database (VLDB)   Partitioned Tables and Indexes in SQL … Continue reading

Posted in SQL server | 21 Comments

SQL Server Interview Questions.

Recetly I come across best interview questions for SQL server from Mr. Dave.   SQL Server interview questions by Vyas     Frequently Asked SQL Server Interview Question in Industry        

Posted in SQL server | 19 Comments