Post the exact errors from the SQL error log (all of them), then switch the DB into Emergency mode and run

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

and post those errors

You...

Rebuild the clustered index.

Actually not. Left joins are...

I am not talking about the *definition* of the queries. To get a deadlock on two...

Yes. Procedure stats is a subset, queries that are also procedures

My intention is to gather...

rocks (1/8/2013)

---

HI,

Thanks for quick reply, I have gone through the post. so what is the best way to avoid this locks. we are using nolock hint...

So test has exactly the same load, exactly the same queries executing as...

You can't. Sch-M is a schema modification lock. Blocks everything and is blocked by absolutely anything, including the Sch-S locks that all queries have to take. Online index rebuilds only...

Brandie Tarvin (1/8/2013)

---

Gail, believe it or not,...

No

No.

Deadlocks occur when 2 pieces of code want the resources that the other is using. It's not a problem of one piece...

I thought you said you were calling the exact piece of code as you gave above, with the declare and set in it?

GSquared (1/8/2013)

---

I believe SQL Server will sometimes shortcut a "Where (select count(*) blah blah blah) > 1" into an Exists() check. But don't count on the optimizer being smarter...

If you solely work with 2008, then I'd say get the 2008 certs. That way your experience will back up the certs. You can always upgrade them later

Extents are just 8 contiguous pages aligned on a 64k boundary.

Anyone familiar with SAP query generator?

http://www.sqlservercentral.com/Forums/Topic1404204-391-1.aspx