GilaMonster (3/28/2011)

---

Isn't that a single session deadlocking itself?

A deadlock between multiple sessions on a...

Please provide some explicit examples of output you expect given certain inputs. This could be a case for either front-end work or dynamic sql.

is this a partitioned table perchance? there is a very nasty bug for those for max/min.

Leo.Miller (3/27/2011)

---

It's relativly unusual to see a single resource deadlock, but it does happen. I've coined the phrase "intra object deadlock". I don't know if the phrase has been used...

John Mitchell-245523 (3/25/2011)

---

TheSQLGuru (3/25/2011)

---

Computed columns would have them paying the price for computations over the course of the entire month. Probably best to take the hit once, unless the...

Computed columns would...

1) I would consider doing both of those updates in a single pass.

2) since you are potentially increasing the length of the address field, you are probably getting lots of...

Outside of having a SAN feature available to allow you to copy/replicate/present this backup file over to the other server SneakerNet is almost certainly your best option. :hehe:

alen teplitsky (3/24/2011)

---

is it better to use a non-clustered index in a large delete? i thought it was the opposite since you would be deleting data that is logically together...

So would I, but I would not be looking to deal with dbcc checkdb issues on a forum - even sqlskills.com. I...

batching with an appropriate non-clustered index seek delete plan (verify based on your batch size - or force it explicitly) can be a HUGE win in large delete scenarios. ...

There are umpteen kajillion reasons why performance varies from one database to another, one query execution to another, etc. Lifetimes have been spent learning what those things are, how...

you should NOT be looking to solve consistency errors from a forum thread. There are SOOOO many variables here and ways you can go disasterously wrong. PLEASE get...

If you are responsible for your company's database server HA you REALLY shouldn't be asking the types of questions you are asking! PLEASE do yourself and your company a...

heavy-duty string manipulations are a good example (especially delimited-string stuff)

heavy-duty or complex math

running totals