Viewing 15 posts - 541 through 555 (of 938 total)
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...
December 19, 2006 at 1:05 pm
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...
December 19, 2006 at 11:24 am
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...
December 19, 2006 at 8:17 am
I figured That post was for Simon, and just built a little on your most excellent work, sir
December 18, 2006 at 2:33 pm
Or you might even be able to use the WHERE clause to combine steps 2, 3, and 4 into one step
What constitutes a...
December 18, 2006 at 8:38 am
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,...
December 15, 2006 at 1:55 pm
“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,...
December 15, 2006 at 12:12 pm
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...
December 5, 2006 at 10:39 am
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
December 5, 2006 at 10:13 am
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...
December 5, 2006 at 8:58 am
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...
December 5, 2006 at 8:49 am
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...
December 5, 2006 at 8:44 am
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...
December 5, 2006 at 8:23 am
Sorry about that Let us know how it turns out, I'd be interested to know. Thanks
November 30, 2006 at 11:25 am
No need to download it Just go to BOL on the msdn2 website: http://msdn2.microsoft.com/en-us/library/ms130214.aspx
November 30, 2006 at 8:44 am
Viewing 15 posts - 541 through 555 (of 938 total)