Is everything slow during the 15 minute period or just specific procedures? Are there blocks happening during the slowdowns?

If you are lucky enough to be connected during...

The DBCC CLEANTABLE is meant to reclain space from dropped varchar columns, not as a maintenace routine. The unused space you are describing is likely due to fragmented data...

You could add a Top 1 to your query and order by priority. Assuming you need the details field. It's that field in your query causing you to...

You are likely onto something with the parallel queries thought (try a MaxDOP of 1 to test it), but remember just because SQL is doing a JOIN with the data...

Well you don't have any WHERE criteria, so you are going to be getting every record except where the JOIN criteria don't match. Your two clustered index scans (essentially...

Yeah, since you are doing the work in SSRS, then you need to remove the quotes. I am curious about the formula though. Can the value be less...

It is starting to make more sense. Gail's questions are important though. What is the data type of the column? What is the underlying query? If...

this sounds like Excel... If there was a problem with the field data, I would image SQL to throw an error versus displaying #Error in the result grid. ...

The error is exactly what the constraint is supposed to do, because it checks to see if there are children records before deleting. If you want to change those...

it's not an association to the temp table. Just use the temp table's key value as your key value in the destination tables. Instead of the PK in...

if you have a PK in your Temp table, why not just use that PK as your identifier in all your subsequent tables?

i agree with the scalar functionality that you are describing being bad. Virtually any scalar using a SELECT is just going to be awful. The scalars i'm talking...

if you are going to use functions, use scalars and not table based for the logic. That should allow you to maintain the code and not take too much...

I was unaware it was a private discussion.

<-- Unsubscribed

When performance is more important than the overhead incurred by the extra work of maintaining information in multiple areas.