I was working on a case where I needed to try something on different Cumulative Updates (CU) to see what the result was in each.  Let me outline the version numbers for the Service Pack 1 release we have to date. Release Version Number SQL 2008 RTM...

See update: http://blogs.msdn.com/b/psssql/archive/2011/02/21/did-your-backup-program-utility-leave-your-sql-server-running-in-an-squirrely-scenario-version-2.aspx

If you use the linked server feature with SQL Server 2005 and 2008, please read through this carefully. We have discovered several problems that can result in memory leak(s). The conditions are a bit complicated so let me try to describe the problems...

Not sure how many of you have started using the new Extended Events feature of SQL Server 2008. For those who have not, there are several good resources out there already for you mostly done by the community: http://sqlblog.com/blogs/jonathan_kehayias...

The ring buffer records (which can be sent to XEvent) for Resource Monitor and Memory Broker are the key aspects to understanding RM.  The record is produced when a change is detected in state monitored by RM.    CREATE EVENT SESSION RingBufferInfo...

I realize that the topic of “locked pages’ and AWE can be confusing. I don’t blame anyone for being confused on this. I also realize we have blogged and talked about this topic many times perhaps “beating it to death”. And I certainly know this is not...

The SQL Product team that owns setup is looking to improve the SQL Express installation experience including application developers who look to embed SQL Server Express with the install of their application. Peter Saddow is a Program Manager on this team...

We now have live an update to the KB article for the Support policy for virtualization for SQL Server at: Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment I created this blog post, because there...

Recently I troubleshooted an issue where a distributed query was randomly getting a poor plan and slow performance where the join would not be remoted.  However, based on the actual data distribution and the join condition, you would expect the join...