I just solved the issue by adding a new index ( not necessary since I was using the clustered one)

the query started working, then I removed the new index and...

ChrisM@Work (6/4/2013)

ricardo_chicas (6/4/2013)

I can't even generate the exec plan. It never ends, and none is using that table since it is a copy of the original

And none is blocking that...

I transformed the data so what I showed is yhe actual query

And the estimated plan never is calculated. It just keeps running for hours until I stop it

All

I can't even generate the exec plan. It never ends, and none is using that table since it is a copy of the original

And none is blocking that spod either

This...

All

Thanks but you are missing the point. The original query was something much bigger

I used a top 1 just to show you that there is something wrong with one of...

The OS is windows server 2008 R2, I already look into the logs and the only thing I saw was a query against one of the bigger tables, nothng fishy...

Hello all

actually all I did was to reate a loop that read the data 10000 records at the time, that allow me to use one of the main indexes so...

Thanks to all

we actually have a need for all that data, I solved it using custom batches

I already did that, the execution time was the same...., the query is too simple, I think the problem is the size of the table and the amount of fields...

Hi

The temp table already have a clustered index, the execution plan is attached, the result table has 5661714 rows and 1.5 gb

any advice will be really appreciated

Thanks

That server use san space, I have two drives but i know that doesn't means that they are fully separate, still I am using a different channel for each one,...

fot the last 16 hours I've been trying to shrink the log file, it is 35gb now, I am the only user, I close all access to the server but...

the recovery is set to 0

the spwho2 shows this

14 BACKGROUND ...

the checkpoint spid is blocking all the other sessions on that databse, I can do anything on that database, I know this is not isolated, internet is plagued with people...

a log backup