There is some merit to storing the following in separate files on separate drives if possible...

Static Tables and monthly archives

Audit Logs

Common utilities and functions, etc

Application stored procedures, functions, etc.

Non-static application...

Proof is always good... gotta love BOL. 😉

Hmmmm... might have to trade in the ol' slingshot... bet it works real good with porkchops...:D

Let's see if I counted this right...

1 Cursor

30 separate SELECTs (many nearly identical) not including the cursor

1 Insert

... per row...

I wonder how long this puppy is going to take to...

Matt's code is functionally perfect and identical in performance (< 15 seconds total duration) to the following code... the only difference is the following code uses a single CTE for...

The following URL seems to have the information necessary...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1175067&SiteId=1

I agree about SQLCompare by RedGate...

However, you have to ask why you want to do this. I find the typical application is to find the differences between a Development...

Something else to be keenly aware of... many databases have views that have no indication in the name that they are, in fact, views... see if the "cc_message" table is...

tymberwyld (3/24/2008)

---

I love how everytime I read about EAVs there's always some quote about performance blah, blah. EAVs have their place and they are good at what they do....

Nope... here's the example from BOL... and, I've tested it... works fine... and despite what it says about schema.ini, you don't need it for comma delimited files.

H. Use the Microsoft...

Heh... nothing to report on... that's "Cohen's Law". Cohen is the brother of Murphy and he states that "The more time you spend on reporting, the less time you...

While we're on the subject...

Thanks to all the folks in the military keeping all of us safe or keeping those that can't defend themselves safe... think of all the birthdays,...

Yeaup... version control is a good thing even if you're the only one doing everything. It's saved my hiney a couple of times...

Maybe it's just me... but, in most cases, I find that "Business Intelligence" is an oxy-moron with emphasis on the word "moron" 😉 ...

I worked for a Fortune 100...

Part I is a good (possibly too brief) introduction to EAV's 😉 Like the other's I'm looking forward to Part II.