**** There is a duplicate post of this question at http://www.sqlservercentral.com/Forums/Topic964052-391-1 that has more posts in it than this one so after looking here, look there. ****

Something like this may...

SQL Server has the DataLength function which returns the bytes needed to store a value. As far as I know SQL Server doesn't need 2 bytes to store the...

I think Jeff, Gail, and Grant covered that one pretty well.

Off the technical and metric time topic (I love non-metric cause I'm an American :-D). Just had my PASS NomCom interview. Hard to tell how it went because...

I was just thinking the same thing. I haven't had a truly technical post in a quite awhile.

Chris Morris-439714 (8/5/2010)

Jack Corbett (8/5/2010)

Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in...

Jon,

Where you place the criteria for OUTER JOIN's DOES make a difference. Whenever you place criteria in the WHERE clause that references a column in your OUTER table SQL...

Without seeing the report and the business use/case for it I'm not sure what to offer. My gut tells me that you need to look at developing a procedure...

It depends on what you think is causing the issue. I'd start with RPC:Completed and SQL:BatchCompleted as these give you CPU, Reads, Writes, and Duration.

WayneS (8/4/2010)

Then it looks like you...

What are you doing in the report that requires 3 datasets that share some data? Couldn't you return the data in one dataset and then use filters in the...

Why do you have 12 datasets? Can't you just use 1 dataset in multiple report regions/items? Are the datasets bring back different data because of different parameters?

You can't use the table alias in the SET Statement. You aren't updating the column in MF, you are updating the column in mitfac. There are a couple...

Try this blog post, http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/29/650349.aspx

Is there a question here?