Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 3,232 total)

  • RE: Back and restore

    It would be great if you knew for sure that it was a good or bad backup; however, all backups would fall into your #3 category.  One never truely knows...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 22, 2007 at 10:17 am

    #714639

  • RE: Back and restore

    You can try a RESTORE VERIFYONLY on the file, but I would suggest restoring the full and incrementals on a test server as this would be the best way to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 22, 2007 at 9:50 am

    #714629

  • RE: Locking question

    I like Sergiy's solution.   Just to add in another option for you, you could use an UPDLOCK hint on your first SELECT from the MyControlTable. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 22, 2007 at 8:47 am

    #714613

  • RE: Data Verification

    Exactly which performance reasons are you concerned about that would keep you from using SELECT COUNT(*)???

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 21, 2007 at 9:00 am

    #714387

  • RE: debugging with query analyzer

    I'm not sure what is going on with your breakpoints as they work fine for me here including the step in/out functionality. The problem with your stored proceudre not updating the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 20, 2007 at 1:10 pm

    #714200

  • RE: ''''joehack''''

    What is the hostname and applicationname values for this entry in Profiler?  Both ALZDBA and mkeast are correct.  Someone is running this stored procedure and then using the statement 'select...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 19, 2007 at 10:49 am

    #713899

  • RE: How to stop a long rollback?

    There really isn't any sort of precedence for T-SQL commands.  The precedence is done in the locking.  Your 'DROP TABLE' command is being blocked by the locks that the ROLLBACK...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 14, 2007 at 4:22 pm

    #713070

  • RE: Calling UDF from constraint

    Put your UDF logic into a stored procedure and only allow inserts to happen through calls to that SP or use an INSTEAD OF INSERT trigger on the table.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 14, 2007 at 3:59 pm

    #713069

  • RE: Compress backup files

    Check out the zip functionality in this link.  It has worked great for me.

    http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 12, 2007 at 1:32 pm

    #712389

  • RE: Bankers Rounding

    Oops, sorry.....

    I guess that we all get to run our post count up in this thread

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:09 pm

    #712121

  • RE: Bankers Rounding

    Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:08 pm

    #712114

  • RE: Bankers Rounding

    Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:08 pm

    #712116

  • RE: Bankers Rounding

    Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:08 pm

    #712117

  • RE: Bankers Rounding

    Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:08 pm

    #712118

  • RE: Bankers Rounding

    Just so you all know, there are definately more than 5 that have been reading this since the beginning. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    June 11, 2007 at 3:08 pm

    #712119

Viewing 15 posts - 2,221 through 2,235 (of 3,232 total)