Stefan Krzywicki (5/17/2013)

---

Lynn Pettis (5/17/2013)

---

Lynn Pettis (5/17/2013)

---

And we have another winner:

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013...

And the trigger definition looks like....

btw, the WAITFOR is not necessary to get that lock. USE ADVENTUREWORKS is sufficient.

Please post new questions in a new thread and give as much information as possible, including errors and the output of CheckDB.

That's a shared database lock. Each and every running query, no matter what it's running, takes a shared database lock to ensure that the database can't be dropped while the...

Grant Fritchey (5/17/2013)

---

And look to the Cost Threshold for Parallelism. Compare that with the costs of the plans themselves. It could be that with different parameters compiled a different times,...

Which one of them?

It's the old way, but it's not...

Delete data, add more space or move stuff to another drive.

As I said, MAXDOP is just the maximum number of processors and MAXDOP 0 means use up to the total number of processors, but it's up to the optimiser and...

T.Ashish (5/17/2013)

---

If I use query 2/3, then optimizer must be converting it in Inner Join before execution. If I'm right then is there any way...

Maxdop is just that, Maximum degree of parallelism, the maximum number of cores that the query can use. A query with MAXDOP 8 can run on a single core if...

"I know the drawbacks of nolock, in our case it cannot be avoided"

Hmm...

Really? So you absolutely must allow potentially incorrect data in results because ....

And regarding...

Personally I'd prefer an update in the form...