The only perfect database server is the one which never gets switched on; or at the very least never has any users* on it 🙂

Paul

* especially database administrators

Well that's the problem with benchmarks isn't it? 🙂

You don't say in your post whether this is causing you problem on a real system or not?

You might be interested to...

Read Uncommitted is not unique in being vulnerable to reading the same data twice:

This is one of many articles on the subject

It is unique, however, in being vulnerable to the...

Yes, and very annoying it is too. You do 'sort of' omit them by including the DEFAULT keyword instead, but that's not really the point 🙂

Books Online

---

CREATE FUNCTION: When...

Hugo,

I don't want to get bogged down here: my point is that operations which remain correct while avoiding a ! or a NOT are generally a better choice than the...

Hugo Kornelis (7/6/2009)

---

I see that you now have made a small change to the explanation, but I still do not like it.

"It is sometimes a better practice to check for...

Ah yes that would probably help wouldn't it!

Going to edit my previous post...

Done 🙂

That looks vaguely like German :unsure:

(Flo: consider Donaudampfschiffahrtsgesellschaftskapitän¹)

edit: better still:

Donaudampfschiffahrtselektrizitätenhauptbetriebswerkbauunterbeamtengesellschaft²

or

Rindfleischetikettierungsüberwachungsaufgabenübertragungsgesetz³

(Ok so I googled)

1: "Danube steamship company captain."

2: "association of...

LOL

edit: you too G²

Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!

🙂

Welcome back. ...

One of today's featured articles[/url] makes me want to cry or take up an alternative line of work, in equal measure.

VAS utilization (especially, but not exclusively, in 32-bit editions) is...

Florian Reischl (7/3/2009)

---

@paul-2: Congratulation to >1000, didn't see this before, now you can call your self a guru :-D. Your new avatar really made me laughing! First I saw Barry...

RBARry's change of avatar caused an imbalance in the force,which has now been corrected 🙂

edit: previous reply made little sense

GilaMonster (7/2/2009)

---

Anyone want to take a stab at this?

http://www.sqlservercentral.com/Forums/Topic746075-360-1.aspx

Converting the while to a select off a (large) tally table's the easy part. The no duplicate values and exact number of...