Shawn Melton (6/9/2015)

---

If you are using SSMS to determine size, have you tried using a query to check if it reports the same size?

Have you issued DBCC UPDATEUSAGE (MyDatabase) WIT...

I haven't try something like that from powershell but sounds like a good idea, the source code will be in github so I am looking at what are my options

Thanks!

thanks

I always try not to use hints because things can change (like another dba dropping an index) and stuff will fail in weird ways 🙂

I just tried that as to...

I had that idea, but well that was letting me rebuild that index so, it was in there...

it seems that dropping and recreating the indexes did the trick

At the SSIS Toolbox there is a "Data Conversion" Component, you can put that between your source and the destination, that I am assuming is a table and change the...

Could you please post the execution plan?

Maybe adding a few indexes at those temp tables it can help, the aggregation is what is killing you

Hi

Have you trying by converting each field to the specific type on the ssis side? there is a component for it

yes, those are based on a full scan

Yeah just the nonclustered,...

Thanks again

I will see what I can find with the stored metrics.

But I still consider this a bug, we create indexes, statistics, keep maintenance's plans and the optimizer just don't...

Thanks

What is really annoying is that I even trimmed the query as to return the same column where I have the clustered index on..

I know that the solutions provided will...

Yes, those are local variables

The option(recompile) or the optimIze hint work, but, MS SQL shouldn't be doing this, I have a clustered index for a reason, I need to trust...

That sounds right, but, what can I do about it?

I can't just go and change tons of code...

The recompile works, the same as forcing the proper index with a hint, but in this case what I really want to figure out is what is SQL thinking, if...