Perhaps the OP has read Ted Codd's "A Relational Model of Data for...

When is something "jiggling" (bad practise) rather than "experimentation" (an essential component of research)? When I'm learning something new, I play with it to see what causes have what...

Good question but wrong answer. And even if the answer had said A and D it would still have been somewhat wrong, since creating a user doesn't give that...

Hugo Kornelis (1/21/2012)

---

L' Eomot Inversé (1/20/2012)

---

But why a clustered...

Revenant (1/20/2012)

---

Hugo Kornelis (1/20/2012)

---

Richard Warr (1/20/2012)

---

Orinstead if from http://msdn.microsoft.com/en-us/library/ms175997.aspx we see that COUNT() returns an Integer. What happens to SELECT COUNT(1) FROM myTable when myTable contains more rows than...

Me too

But why a clustered index? That table might...

Evil Kraig F (1/19/2012)

---

Scott D. Jacobson (1/18/2012)

---

I'm trying to join 2 tables. This is a one-to-many (1-N) join. I have a table with accounts and another table with...

SQLKnowItAll (1/19/2012)

---

L' Eomot Inversé (1/18/2012)

---

Brandie Tarvin (1/9/2012)

---

Craig, I get what you're saying, but I can't figure out how to pass the error outside of the code context to fail the...

+1 (where "people" = "wife")

Good question.

I thought that firing triggers would be on by default in a fast load (no real reason for thinking that, it just seemed reasonable) but there might be an...

Ran into the most assinine piece of spelling naziism today.

Some propsals for spelling reforms for French were formulated back in 1990. They were approved by l’Académie française quite quickly,...

Cadavre (1/18/2012)

---

Although the dynamicSQL is not meant for human consumption, when digging into older code it's always helpful to add PRINT to see what has been generated. Without the...

Scott D. Jacobson (1/18/2012)

---

I'm trying to join 2 tables. This is a one-to-many (1-N) join. I have a table with accounts and another table with information about those...

Brandie Tarvin (1/9/2012)

---

Craig, I get what you're saying, but I can't figure out how to pass the error outside of the code context to fail the job step itself. Raising...