David Portas (11/17/2009)

---

Every other major programming language benefits from strong typing. No C++, Java or C# developer I know of would dream of doing without it....

JacekO (8/20/2009)

---

Scary part is over 30% (at the time of this post) got it wrong. Many QoDs are quite tricky but this one is very basic and really not SQL...

sjimmo (7/29/2009)

---

I had the correct answer as well, until I reread the question, which specifically said to run that code, and actually had a correct answer to it. Thus, 40%...

Oh **1t! 600+400 > 900. And I was a mathematician, once upon a time. How did I get that wrong!

the statement "Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database." in 2005 BOL was a...

john.arnott (2/26/2010)

---

Aside from the typo, this was a good one. It introduces the concept simply and provides a good resource for further understanding. Although I'd learned long ago...

steve-893342 (2/28/2010)

---

OK then, let's take a look and up the ante to 4 billion rows at the same time.

Database in SIMPLE recovery mode.

ZERO growth in database files.

ZERO growth in tempdb...

A useful and interesting editorial.

I think there may be a cultural difference between the two sides of the pond, or maybe between two different kinds of company.

In my experience people...

The given answer is clearly wrong: as well as the two options suggested, the "promotion" option should be included - it would be terrible luck to get promoted to...

Nice editorial, interesting topic.

I was amazed to see in one of the articles linked to that a third of people think sticking the data out in the cloud will reduce...

CirquedeSQLeil (2/26/2010)

---

Thanks for doing that. I will test it out and see how it works. Do you mind if I use this code for an article (blog or...

I can cut somewhere between 0.2 and 4 per cent off the elapsed time at 150000000 rows for Jason's method (but limiting scalability to 4 billion rows instead of 1000...

paul.goldstraw (2/25/2010)

---

I would say fixed width makes it easier to indent your code since every character fits in a same size block. For me, that's the only reason, it's...

It wasn't...

reidres (2/24/2010)

---

OK, Tom. The thing with your TSQL seems to be that while you are indeed generating the numbers, you are not specifically doing so in a way that...