February 20, 2009 at 12:30 pm
It is important to test and be sure. You might have great techniques in your toolbox, but they won't always apply.
One of the weird things about SQL is your "rules" for development may morph slightly in your own database over time and depending on the situation.
February 20, 2009 at 12:52 pm
Nicely put Steve.
I will never give a definite answer if asked if something is going to work unless I test the crap out of it. Been burned too many times on things that were sure to work but did not.
And even solutions provided on the forums should be always used with a grain of salt and be properly tested because they may not work properly in your case. One example might be yesterday's script of the day (at least I think it was yesterday). The one for searching text of the SP, VIEW or UDF. It works fine 99% of the time but on long methods it might not. It might miss some of them.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
February 20, 2009 at 1:37 pm
Back from lunch. No disagreement on the need to test, and to test with expected production volumes. Some techniques work faster for smaller number of rows than for large numbers, and the answer to most questions is usually "It depends."
I just blinked when I saw the word "probably", because to me that means more often than not, and read like a blanket pronouncement that you shouldn't worry about indexes for tables of a couple thousand rows.
Y'all have a good weekend. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 21, 2009 at 12:54 am
Indeed.... we live by a couple of rules, but a ton of guidelines.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply