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 http://www.microsoft.com/sql/prodinfo/previousversions/scalability.mspx   SQL Server Scalability FAQ http://www.microsoft.com/sql/prodinfo/previousversions/scalabilityfaq.mspx   Best practices for Microsoft SQL Server 2005 on HP Integrity Superdome servers for Very Large Database (VLDB) http://h71019.www7.hp.com/ActiveAnswers/cache/444752-0-0-0-121.html   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.   http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers-complete-list-download/   SQL Server interview questions by Vyas http://vyaskn.tripod.com/iq.htm     Frequently Asked SQL Server Interview Question in Industry http://www.dotnetspider.com/kb/Article1659.aspx        

Posted in SQL server | 19 Comments