I prefer to do the client-side scrubbing and add the check constraints just as a safety net (mostly for developers who like to try to shove crap data into tables...

And why can't you?  Triggers are a well-defined and pretty flexible solution.  Here's a very simple example that constrains the value of an INT column on a table to values between 1...

Here's the thing...

You say the data is "dodgy", and errors out the process at times.  I assume by "dodgy" you mean that the data is probably violating some constraints on the...

I figured That post was for Simon, and just built a little on your most excellent work, sir

Or you might even be able to use the WHERE clause to combine steps 2, 3, and 4 into one step

What constitutes a...

Not implying by any means that you're stupid.  I just wanted to make sure we're on the same page when we talk about "client-side validation".  From a Web Designer's perspective, for instance,...

“Validation must be performed server-side. You may (and should also add client-side validation to speed up the user experience and save server round-trips for those users whose browsers support it,...

LOL.  Too numerous to count.

One of my favorites was when the owner of the small business I worked for (which shall remain nameless...) called me into his office and went...

LOL.  I just spoke with your bosses, they're treating you like the lobster...  slowly heating up the pot so you can't tell your soul is dying...  j/k

Ahh I thought he was using a regular table, and not a table variable.  Of course you're right, you can't manually create indexes or statistics on a table variable.  You...

I disagree.  As antares pointed out, a lot of the more experienced folks (like yourself most likely) have lived through a situation or two like this, so an article like...

I hate office politics   And it always seems like the most talented IT professionals just aren't properly equipped to deal with all the backstabbing...

You might want to turn auto-create statistics option and auto-update statistics option on for the database, if possible.  If not, create your statistics on that table and I would recommend...

Sorry about that Let us know how it turns out, I'd be interested to know.  Thanks

No need to download it Just go to BOL on the msdn2 website: http://msdn2.microsoft.com/en-us/library/ms130214.aspx