October 20, 2010 at 1:23 pm
Comments posted to this topic are about the item Common SQL Server Mistakes
October 20, 2010 at 3:24 pm
Steve, nice info for a beginners tract on a SQL Saturday. Now how to lure you to SQL SAT #60 (Cleveland)...
October 20, 2010 at 3:26 pm
I'll try to make it. Not sure about the timing
October 20, 2010 at 3:29 pm
Well, apparently sign me up, shame I'm nowhere near it.
Anyone give me the short form as to why these two are included?
IS NULL
Multi-row triggers
I wouldn't consider auditing an edge case for multi-row triggers, and I'd want to audit on the bulk change.
IS NULL I use a lot, though that may have more to do with not being as familiar as I should with EXCEPT and/or MERGE and use it against left joins a tremendous amount. Unless this discussion is focusing on its usage under AND ( @blah = blah OR @blah IS NULL) in WHERE clauses.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 20, 2010 at 3:36 pm
The presentation talks about people writing "=null" not "is null", and gives the latter as the proper way to test for NULL.
Multi-row triggers are something that people commonly do not write as well. Too often I find people writing select @i = ID from inserted and not accounting for multiple rows.
October 20, 2010 at 3:42 pm
Steve Jones - SSC Editor (10/20/2010)
The presentation talks about people writing "=null" not "is null", and gives the latter as the proper way to test for NULL.Multi-row triggers are something that people commonly do not write as well. Too often I find people writing select @i = ID from inserted and not accounting for multiple rows.
Ah-ha! Mistakes while using them, not the mistake is the use of. That makes a ton more sense. Thank you for the clarification.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 20, 2010 at 3:44 pm
Steve Jones - SSC Editor (10/20/2010)
I'll try to make it. Not sure about the timing
Thanks for considering it (us) ....
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy