Raju Lalvani (3/26/2010)
It is rather strange that our faith in answers posted on the internet are taken as "Gospel Truth" :-). We generally pick up the first few answers returned by a search engine, implement it and then figure out that was not the best possible :w00t:;. We need to spend more time in figuring out, by going through the other search results and figuring out which would be a possible solution.
Did anybody ever tell you that if you Drop the Master dbs, you'll no longer have *any problems* with your servers?
mainly because you won't be working there anymore...
If we don't find out WHY something works, the pros and cons of it, etc, before implementing in production, then yeah, we definitely need to change our patterns.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."