I have received numerous questions about 'foreign pages' so I have put this post together to answer the questions. The SQL Server buffer pool goes through three (3) distinct states. Initial / Ramp-up This state is established during buffer pool initialization...

I have spent probably hundreds of hours on cases involving TCP Offloading and I know most of the signs (intermittent dropped connections, missing traffic in network traces).  However, I have to admit I got burned by it the other day and spent several...

Often we run into situations where there is a need to add a trace flag or a startup parameter other than the default startup parameters that SQL Server uses. What you may notice sometimes is that even after adding these parameters/flags, the desired behavior...

I’m very excited to be invited back to speak at the SQL European PASS Summit 2010 being held in Neuss, Germany April 21-23rd 2010. This is my 4th PASS Summit to speak in Europe and my 3rd year in a row to speak at the location in Neuss. I always enjoy...

Please note: Important changes to the support lifecycle policy for service packs that affect this blog should be read first at: http://blogs.msdn.com/psssql/archive/2010/04/13/an-important-change-for-the-microsoft-lifecycle-support-policy.aspx Based on...