I don't see the link, could you repost, from PM I guess.

Wow, need a break!

Why bother with right?

SELECT 1 000 000 + CONVERT(INT, ID) WHERE ID < 1 000 000

ddl = data definition language. Basically the script to recreate the table in question in this case.

We would have seen float for the id and spotted the problem in...

Eddie Wuerch (8/10/2011)

---

Having 512GB of memory lets me think you have a lot of CPUs in that box as well.

If you're seeing loads of CMEMTHREAD waits in SQL Server 2008...

Create the new server from scratch with all sps and windows updates.

Test the process. Backup on 2k5, to a local drive (shared). Restore from 2k8. Du your...

Easy test, do a select into of that column in a temp table but convert to int in the process then rerun your where. You should see the correct...

That's what I knew, but it just read funny in my head, don't know why...

What's the datatype of the id?

Are you sure this is the actual statement you are running? That just doesn't seem to be possible.

NP, you'll get both now.

😉

Only...

I'd bet on blocking or accidental cross join.

can you post your query and estimated execution plan?

You can't see objects if you don't have permissions on it.

Please post the actual execution plan of the query in question.

Either the load on the server changed drastically, amount of data to process or the plan changed...

Can you rephrase Gail? No sure your statement makes sense.

Do you mean that locks ar not taking place at all?

Please don't cross post. It fragments replies and waste everybody's time.

No more repllies please, continue the discussion here : http://www.sqlservercentral.com/Forums/Topic1157732-149-1.aspx