Roger Sabin (12/21/2010)

---

I tried deleting just 10 records directly as follows:

delete from tblDocument where DocumentID in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

The delete ran for over...

As long as you understand the consequences and limitations, and the optimizer can...

SQLkiwi (12/18/2010)

---

I took a stab at 1,30. So it was 1,*. Ha, very good. I'll have forgotten this again in half an hour, and I still won't...

Nice article, thanks!

We have found the same thing in our process, that it is faster to completely rebuild with an INSERT INTO a blank table, than it is to try...

Thanks for the question, though it had been edited by the time I got to it.

Thanks for the question!

I'm still surprised by 9% of the people getting it wrong, so I guess it doesn't hurt to go over the same thing multiple times.

Jamie Longstreet-481950 (12/16/2010)

---

I like it as is. There are purposes for shrinking. It is easy to do. It is a well-known fact that shrinking a...

Like a lot of other people I never even knew of STR(), I have always used CAST/CONVERT with a RIGHT to get the results I needed. But now I know...

Thanks for the question!

Thanks for the question, I learned a couple things. 🙂

Thanks for the interesting question. Though I hope questions like this wouldn't be necessary, and that people would always specify a length on variables to keep themselves out of trouble.

I think shrink should be made a manual only process that requires you to type in a CAPTCHA phrase while reading a warning about what will happen to your database....

Thanks for the question, I have run into this before so I knew it right away.

Interesting question, I got it right by process of elimination. (Too lazy to do the math tonight.)

However, I probably wouldn't use that method to populate a date table. The numbers...

Thanks for the question, but like others said the explanation could have been a little better, like mentioning that this applies to NOT IN. (It doesn't apply directly to IN.)