I attached a docx with 3 images. One from BIDs which works fine, one upon rendering, and one after you scroll down.

I realize you post is rather old but I'm having this issue too. I have the line added but it's not displaying.

My report of course uses a t-sql dataset.

Not sure what difference it makes but my old machine was Vista 32 bit and my new one is Win 7 and 64 bit.

Thanks in advance for any assistance...

I set the min and max to the default (my min was 1248?) now a simple select from a table of 125 rows just took 20 seconds. I just...

So what would I set it to. I will definitely try that.

No I'm not vpn'ed in - but that what it feels like.

But I did remote into that server and didn't have the issue. Same for all servers - slow. So it's just my machine. It's like it's verifying...

2005 SSMS

Passing Multiple Parameters to a Stored Procedure

1.Define your parameter in your stored procedure as xml

IE: @DEPART XML

The parameter now acts and behaves like a table

IE: INNER JOIN @DEPART.nodes('/DEPART/LOCATION_DESC') as m(item)...

Well I wasn't actually smart enough to go look at BOL. I ran the SHOWCONTIG and was looking in that output. See I learned a lesson too! ...

Found 'example E' - thanks for your help.

yes I did SHOWCONTIG - sorry - but I still don't see example E... found some other examples ie SELECT TOP 10 ObjectName, IndexName,MaxRecSize - so something like...

I hate to be dense - but where's example E? I ran the showconfig and it's full of cool info...

Would you share that code? We have 2 jobs one that loops through to rebuild indexes and one that's an SSIS package - and does all tables. I've...