Viewing 15 posts - 51,391 through 51,405 (of 59,072 total)
He's all your's, Barry 😉 Send him an email 🙂
March 31, 2008 at 5:08 pm
Babu_Raj (3/31/2008)
EXEC sp_track_db_growthGO
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...
March 31, 2008 at 5:06 pm
... and, no matter how you shape it, a cursor or While Loop is going to kill performance.
March 31, 2008 at 5:02 pm
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...
March 31, 2008 at 4:58 pm
Andre T (3/31/2008)
So, basically, I do need the trigger to call my stored procedure for each item changed.
Absolutely NOT! That's RBAR on steroids and it will crush any hope...
March 31, 2008 at 4:54 pm
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...
March 31, 2008 at 4:49 pm
Ahmad Osama (3/27/2008)
souLTower (3/27/2008)
-- Remember to use procs to eliminate SQL injection
SELECT cid from CompanyNames where cname = [user...
March 31, 2008 at 7:06 am
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...
March 31, 2008 at 7:02 am
It would be much more effective to output your data to a file and use Word to do a MERGE document.
March 31, 2008 at 6:53 am
Heh... Gail is spot on... and it ticks some of us off so bad, we won't respond with anything useful.
March 31, 2008 at 6:52 am
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...
March 31, 2008 at 6:50 am
Jack Corbett (3/30/2008)
March 31, 2008 at 6:02 am
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...
March 31, 2008 at 6:01 am
Robert (3/31/2008)
Maybe because he/she means the broader meaning of cursor.
Considering the level of the question, I wouldn't think so. I sure wish the OPs would answer these questions so...
March 31, 2008 at 5:51 am
Viewing 15 posts - 51,391 through 51,405 (of 59,072 total)