Jeff Moden (4/18/2010)

---

Right now, I'm testing with the FULL recovery model. I'll follow that up with the SIMPLE model but most folks don't run SIMPLE recovery on databases they...

It sounds like good news.

Perhaps they are trying to spread the behaviour of the more helpful support staff to other parts of the support organisation (my experience in...

Paul White NZ (4/18/2010)

---

Hugo Kornelis (4/16/2010)

---

Second, Field 1 is not actually the object id of the column, but rather the column id. Columns are identified by a combination of object...

Paul White NZ (4/18/2010)

---

Actually, pretty much every other post so far has covered it :w00t: and Rune responded:

"Yep, I...

All sorts of things are good if they are handled properly, and utterly demotivating if they are not. Someone could give me a cheap and nasty plonk, doing it in...

mark.pleasance (4/16/2010)

---

I work for a SMB beverage alcohol import agency . . .

(much removed)

Now - mind you . . .

It is fully expected that (if needed) you will...

Mike C (4/17/2010)

---

The vast majority of ETL solutions I've encountered tend to discard a lot more duplicate rows than they update or insert (after the initial table load, that is)....

Steve Jones - Editor (8/13/2008)

---

The correct answer, according to that link, is a rowversion data type. This may be stored as binary(8), but there is a special type for it...

This is one of those cases where MS contradicts itself, BoL says in one place that the limit is 256 and in another place that there it's limited only be...

ditto. I won't post the code I put together after blinking, with boggled...

This sort of thing scares me rigid. The warning at the end is nowhere near strong enough.

Whatever sort or profiler run you use, or whatever sort of trace, you...

Mike C (4/17/2010)

---

This is why I recommend SHA-1 or better (probability of collision for 160-bit hash is 2^80 per the birthday paradox). Even the current crop of theoretical attacks...

Hugo Kornelis (4/17/2010)

---

Hi Tom,

I...

CirquedeSQLeil (4/17/2010)

---

The changes are trivial. The biggest piece of note is that there really is no notes as to the changes made (i.e. dates etc). It still uses...

Hugo Kornelis (4/16/2010)

---

Nice question, Ron. I do not agree with Jason about the importance of the information though - it is interesting to know, but absolutely irrelevant for our jobs....