I had noted your post...

Wagner this is a great article. I gave it all the stars. Then look at the other results. Seven pages on the forums. If you have...

Actually, Cris, I was referring to you (Chris.Strolia-Davis). The way UNION (and ALL) works is to take multiple result sets and merge them together. It almost does not...

Sorry. I had copied this querry from the net and fixed the joins. The original just had all the...

Richard Gibbins (10/7/2009)

---

Thanks for a lucid article. I'm from the "old school" so this cemented what I had picked up ad hoc.

I have a quick question however. I...

Chris,

Not exactly. The UNION / UNION ALL is kind of tough one to get wrapped around. UNION ALL combines two or more identically structured result sets into...

Great article. Very good primer on the subject. When you do your next one on advanced joins please talk about moving thing from the WHERE to the ON...

What? You have to preallocate the space for that table? What DBMS is this? Must be...

Unfortunately it's not all that strange. when i was working for the dental software company we were required to add a diagnosis code field to every treatment. Insurance,...

Cause and effect, folks. Cause and effect. Who knew that this cause would have that effect. Fire? And here I thought that vengeance was a dish best...

timothyawiseman (10/1/2009)

---

Perhaps I am missing something. You should be able to restore it to 11PM on Thursday when the last log backup was taken, presuming of course you still...

Thanks Jeff.

The next one will be better though. It's another learning experience. Thanks to all the responders too. I take no exception to anything that was said....

I just did Adi. Thank you. Very surprising. And here I was patting myself on the back for having all my research down. Then again one...

David you are lucky. I've had that too. Mostly this is due to the databases having a high read to write ratio. This increases the probability that...

Vliet is correct. So are many of the other points raised. Yet there was one thing missed. Yet we have seen the following many times:

(1) Set up...