I wouldn't store a duration. I'd store the start and end times and calculate duration when querying it. The UI can ask for a start time and a...

Sounds like both bad statistics and parameter sniffing. One could potentially lead to the other. Once stats are updated you can work on the parameter sniffing by using...

I prefer to have a specific table for a specific purpose. It makes RI easier to enforce.

Slick, you need 2008 R2 tools in order to see anything in the object explorer.

Are you using the MSI to install? I just tried to install and the MSI didn't work, but using the zip file and running the scripts went fine.

Maybe try this http://msdn.microsoft.com/en-us/library/dd283097.aspx

Unfortunately that's all the help I can offer at this point. May be able to try it out later though.

Grant lives in Southern New England, it doesn't even really get cold there and they...

Please post the Graphical Execution Plans for both statements. Basically it looks like the Optimizer it taking 2 paths to get the data based on the columns requested. ...

Do you have FileStream enabled? It is the filestream store that you are having issues with.

I figured the SQLCLRManager was custom. I think your error may be "bubbling up" from there. Are you using any COM components in the SQLCLRManager? I ask...

Sure you can do what you mention in your example. You don't even need subreport, unless you are basing the subreport on data in the main report dataset.

You would...

IN 2005 you can also use sys.sql_dependencies which can even take you down to the column level.

Michelle,

There are a lot of variables involved here, as I'm sure you know. First, without seeing the SQL being called it can be difficult to troubleshoot. Here are...

The problem is that the transaction log on your test server is filling up and you don't have autogrow enabled. You have a few options:

1. Manually resize the...