OK, guys.

The way I reckon this'll work is that soon, Steve'll come here, read Pablo's post about dob not being a field in the table being queried, will realise there...

Shaun McGuile (4/4/2008)

---

Hugo:

That is exactly why I've invented the ShaunyByte!:D

A single BS is all you need, no matter how much data you have.

the expanding BS is given an order to...

He, he. I liked this question.

However, I'm intrigued about that last comment - about a yobibyte theoretically being big enough to contain all the information in the universe. More particularly,...

Guys

We now have 12 pages of posts. I think I'm right in saying that an answer for EVERY POINT RAISED is given on EACH AND EVERY PAGE (with the probable...

Sir, you're a saviour.

And Mr Moden's a bl**dy genius.

Thanks indeed.

As I see it, what most people are answering, and what the explanation says is correct, are the same, but that a mistake has been made in the configuration of...

Question:

How many DBAs does it take to change a lightbulb?

Answer:

Which version?

Why change it? It works for me!

Have you tested the lightbulb, or is it just theoretically not working?

Etc. etc. etc.

:Whistling:

Wow. Seven pages already!

OK, a summary. What this question has illustrated:

1. There are practical version differences between SQL2K and SQL2K5 regarding T-SQL handling.

2. If you work on "theoretically correct" and...

Chris Morris (3/31/2008)

---

Kev

Try this in a SQL2k query window:

select OrderDate, * from Northwind.dbo.Orders order by OrderDate desc

Yes of course...

@kenny, is the database you tried your query against set at compatibility level 8.0? If so, you're right that it'll work fine. However, changing the compatibility level to 9.0 (obviously...

Hmm.

We have a multiple guess question that asks, "if you do this, what'll happen?". There isn't an option for, "in some situations this, in others that", so either there are...

If I'm honest, I think the question's being tackled from the wrong end. As Steve alluded, it's the (mis)use, potential or real, to which the data is put that is...

@Loner, the major assumption you're making is that the threat to your company's data comes from outside. It's amazing how many threats come from inside the company (disgruntled employees, people...

Couldn't agree less with the baseball, Steve (being a Brit, baseball doesn't float my boat ;)), but couldn't agree more about periodic restores.

It's drilled into us all as IT workers...

Because OK is a variable term. Generally, manufacturers don't do things for...