Thnat's crazy. There's no way he could rate higher than a 1.

Evil Kraig F (9/21/2012)

---

I'm also not a particular fan of TFS, SourceSafe, or the rest in the database world. I'm VERY frickin' biased against this, particularly because of the...

Phil Factor (9/17/2012)

---

The idea of saying that one should never do shared database development is ridiculous, ... ... ... to try to anathemise or prescribe the perfectly reasonable practice...

Steve Jones - SSC Editor (9/17/2012)

---

Jeff Moden (9/16/2012)

---

I've found that such "committee decisions" can be horribly wrong especially when people who might not know as much about databases outnumber those...

I thought that was what I said.:-P

Steve Jones - SSC Editor (9/26/2012)

---

SQLDBA360 (9/26/2012)

---

Steve Jones - SSC Editor (9/21/2012)

---

The question was poorly worded and I missed the total disk activity in edit.

The question has been corrected and...

Nice and easy. Thanks for the question.

Yes, adding those two lines fixes that issue.

However, you will have very poor performance...

Good question.

Nice blg entry too, apart from "BACKUP/BACKUP" instead of "BACKUP/RESTORE".

Your loop doesn't insert any data - it just repeatedly overwrites the command's parameters. The only calls to the database are befor the loop begins and after it ends,...

Sean Lange (9/24/2012)

---

Tom I was typing before I really understood the question completely. Maybe if I had used the word history instead...

Sean Lange (9/24/2012)

---

Gazareth (9/24/2012)

---

Hello,

I seem to recall from my database design classes a while back, being told that a link table with just a datetime field in wasn't really a...

Gazareth (9/24/2012)

---

Hello,

I seem to recall from my database design classes a while back, being told that a link table with just a datetime field in wasn't really a link table.

I've...

Good question. Nice and easy, and no scope for disagreement/nit-picking.

Unless of course this is a nit: I find the terminology in the explanation's first sentence somewhat amusing, though -...

SQL Kiwi (9/23/2012)

---

[Just in case you are not aware of it, there is some very good information at http://www.wiscorp.com/SQLStandards.html and a reasonable version of SQL:92 at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt (CREATE ASSERTION is...