Thanks guys for your input.

I was trying all function parameters however with sampled I should have got also proper result set, so 3 indexes.

Of course my query could have been...

Sure:

SELECT i.name, f.*

FROM sys.dm_db_index_physical_stats(10, 165575628, null, DEFAULT, 'sampled') as f

join sys.indexes i

on f.index_id = i.index_id

where i.object_id = 165575628

Thanks Sergiy for the query!

I was able to overload my CPU with it and with the A.Mechanic tool http://www.datamanipulation.net/SQLQueryStress

The query was run in multiple threads.

Thanks Chris,

As I wrote I was using multiple joins with aggregations on my test tables which have many millions of rows.

This index query is not making any difference for a...

Thank you for your answer.

Yeap, indeed I had input wrong fill factor number which was 0 and I should have input 100. Providing 0 to the formula breeds divide by...

It really helps me with landscape printing. Thanks for the tip! :w00t:

If you have created database's script from SSMS you could have enclosed starting file size i.e. 8GB.

It takes time for SQL Server to allocate big data file on physical...

Thanks for tips, all were helpful!

Cheers,

Bartek

Hi Yuri,

Thanks for reply and additional tips.

I followed Nick's advices and I could not find "Series Style" button, that's why I asked you.

It seems that I have old Report...

Hi guys,

This looks like basic problem when you tackle with some RS chart, and now I have gone into it but on SSRS 2000.

Have you already found how to programme...

Thanks Grant for help, certainly I will use your advice.

Sorry guys, my question is related with SS2000. :blush:

But I think it is irrelevant in this case.

Any way, do you know how to move this post to SS2000 forum...

Hello,

I encountered exactly similar problem, on LiveDB few queries are slower than on test DB. I run profiler and it is clearly visible that the same select query has more...

Thanks guys for response.

@lowell: I provided this error as example of incompatibility issues, most of them in my environment was actually related with lack of “with” keyword

Thank you for your responses.

I was looking for a hack but it seems I will have to wait till evening to fix dependencies. No drive is in the resource...