He's all your's, Barry 😉 Send him an email 🙂

I agree... such a sproc is NOT provided by MS in any installation of SQL Server 2000... would you post the code for this sp_track_db_growth sproc that...

... and, no matter how you shape it, a cursor or While Loop is going to kill performance.

Heh... understood. Been there and done that. Not fun no matter which way you do it.

I agree with most of the others... log shipping is probably the best...

Absolutely NOT! That's RBAR on steroids and it will crush any hope...

Lots of great ideas on this thead...

At this point, I'd have to say "it depends"... like has already been said, both UDF's and Views can be written in horribly incorrect...

Ahmad Osama (3/27/2008)

---

souLTower (3/27/2008)

---

If you have a table called CompanyNames you can query like this:

-- Remember to use procs to eliminate SQL injection

SELECT cid from CompanyNames where cname = [user...

In almost all cases, neither a cursor nor any form of a While loop are required especially in SQL Server 2005.

Lots of folks use the guidline "when it can't be...

It would be much more effective to output your data to a file and use Word to do a MERGE document.

Heh... Gail is spot on... and it ticks some of us off so bad, we won't respond with anything useful.

On the subject of "Derived Tables", look into CTE's... they make for easier to read code and can be self aliased, if need be, without duplicating the "sub-query".

Also, take a...

See? Exceptional DBA... 😀

Jack Corbett (3/30/2008)

---

I have nothing against getting a degree, but, as Jeff said, I am not sure what you gain on top of your experience. Do you feel green...

Sam's example is not an exception, either. I've heard the same story more than once.

Also, Sam is spot on about "hard work" and "common sense". There are a...

Considering the level of the question, I wouldn't think so. I sure wish the OPs would answer these questions so...