CSS SQL Server Engineers

I’ve seen several cases that involved Multi-Value Cascading Parameters and how the behavior of those work.  Let me start with the default (Out of the box) behavior.  The example report I’ll be using will make use of the AdventureWorksDW sample...

We have had a number of people ask about how they can get the Jet ODBC driver/OLE DB Provider as 64 bit.  Windows only ships the 32 bit versions of these.  The answer is that the windows versions won’t be x64 as those items are deprecated. ...

We have had some customers who reported to us that their queries consumed more CPU in SQL Server 2005 after they upgraded from 2000. When you examine the plans. Both are very similar. But SQL Server 2005 has something extra. It has "OPTIMIZED" keyword...

Microsoft SQL Server support team received several support incidents from SQL Server Customers who observed a strange issue when executing DBCC CHECK family of commands against their production databases. We investigated this problem and found a resolution...

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  ...