Forum Replies Created

Viewing 15 posts - 541 through 555 (of 938 total)

  • RE: Eliminating Cursors

    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...

  • RE: Eliminating Cursors

    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...

  • RE: Eliminating Cursors

    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...

  • RE: Eliminating Cursors

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

  • RE: Eliminating Cursors

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

    What constitutes a...

  • RE: Updated SQL Injection

    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,...

  • RE: Updated SQL Injection

    “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,...

  • RE: Developers and DBAs

    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...

  • RE: Developers and DBAs

    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

  • RE: Eliminating Cursors

    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...

  • RE: Developers and DBAs

    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...

  • RE: Developers and DBAs

    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...

  • RE: Eliminating Cursors

    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...

  • RE: optimising the procedure

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

  • RE: New T-SQL Features in SQL Server 2005 Part 1

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

     

Viewing 15 posts - 541 through 555 (of 938 total)