If yes, say which Connect item you want and why. Let's discuss this here so we can focus on creating the ads we already agree on.

share
    
Mods: Couldn't add community-ads tag to this question. –  Nick Chammas Jan 25 '12 at 3:46
    
Yeah, you don't really get to add that tag. –  jcolebrand Jan 25 '12 at 4:09
    
@jcolebrand - Yes love, but you can. :) 'Tis appropriate, is it not? –  Nick Chammas Jan 25 '12 at 4:10
    
'tis not. they fit a certain format of post. –  jcolebrand Jan 25 '12 at 4:11
    
    
@jcolebrand - Oh, only that type of thread may have the tag, eh? OK. Well, do we need a new thread for Q1 2012? –  Nick Chammas Jan 25 '12 at 4:18
    
Sure, if people are gonna make such ads for it –  jcolebrand Jan 25 '12 at 5:01
    
I think this is a great idea –  Jack Douglas Jan 25 '12 at 18:35
1  
Not sure how much attention they actually pay to these suggestions. e.g. still no CREATE OR REPLACE after 7 years and 335 upvotes. –  Martin Smith Jan 25 '12 at 18:39
    
@MartinSmith: there as an admission that unless active and nagged and pushed by MVP types, they fall off the radar. Dunno where I saw that. –  gbn Feb 1 '12 at 8:28
add comment

1 Answer 1

SET STRICT_CHECKS ON

Erland Sommarskog's full explanation of this suggestion is here. The main benefit to implementing this is speedier development and easier troubleshooting for silly but common errors.

From Erland's Connect suggestion:

As programming environment SQL Server has shortcomings that are entirely inappropriate for enterprise development. In a modern programming language, the compile tries to catch as many errors as possible. The earlier errors are found, the cheaper it is to fix them. And nothing is as cheap as a compiler slapping the error in your face.

SET STRICT_CHECKS ON would enforce several compile-time checks that would ferret out easy errors--errors that are currently not caught until run time and are also poorly reported on.

share
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .