Summary On a sporadic basis you may encounter any one of the following errors while rendering reports in Reporter: Index was outside the bounds of the array. Object reference not set to an instance of an object. Fix The following Reporting Services hotfix...

SQL Server Books Online uses the terms super latches and sub-latch to describe them.   For example the SQL Server:Latches performance counter group calls them super latches.   The DVM that exposes the super latches use the term sub...

You can place ORCA on a central computer and allow it to control the sequencing from multiple client computers running OSTRESS.    To accomplish this you must configure the firewall properly. Note: Be sure to install the same version of...

I worked on an interesting issue today and the outcome deserves a post.  The issue was that when auto update statistics executed the query went from 6 seconds to 6+ minutes. select count(*) from tblImageData where blobData is null Turing on the SP...

Summary We've lately gotten several questions from users regarding ReadTrace and how to workaround when your input trace files contain MARS (Multiple Active Result Sets).  ReadTrace currently does not support processing MARS and you will need to...

Recently one of our blog readers reported that when they tried to change the SQL Server account password in SQL Server Configuration Manager they were getting "WMI Provider Error Access is denied [0x80070005]".  This was happening on two...

Here is a question I was recently asked: " I am counting pages in the buffer pool using ' Select count(*) from sys.dm_os_buffer_descriptors' and I g et 6,460 buffers but when when I look at the Buffer Node:Database pages counter it shows 6,599.  ...

Sarah and I have been approached by several customers wanting to know more about sparse file allocation behaviors.   This post attempts to answer those questions. Previous Posts http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports...

I ran across an interesting issue when trying to install the Reporting Services Add-in for SharePoint on a Windows 2008 server.  We would get the error listed above when trying to install the Add-in.  We choose repair on the Add-in component...

At first glance it appears that ReadTrace has generated an unexpected connect node.  Upon closer inspection the behavior is correct in order to maintain the proper set options for the connection. Trace has both physical and logical connect/disconnect...

We are often asked how to extend the filtering of RML (ReadTrace/OStress) or Profiler.  Filtering during trace production is the preferred method because it typically reduces the overall impact of the Trace on the SQL Server throughput.  ...

Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds. An application that uses the Sxs.dll file crashes...

When you attempt to change the Login Account for the SQL services [SQL Server, SQL Agent, Full Text, Analysis Services] from the SQL Server Computer Manager tool, you may encounter the following error message: "WMI Provider Error" "Access is denied...