Forum Replies Created

Viewing 15 posts - 19,786 through 19,800 (of 26,490 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/13/2009)


    Lynn Pettis (7/10/2009)


    On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.

    For that matter, anyone heard from Grant? I think...

  • RE: The Worst Advice

    rf44 (7/12/2009)


    Lynn,

    I never said it was an answer you see all the time. I just replied to the question "What's the worst SQL Server advice you see regularly", and believe...

  • RE: The Worst Advice

    rf44 (7/12/2009)


    Maybe I should precise that I never intended to promote or even condone the use of cursors. I know that cursors are not efficient tools in MS SQL Server...

  • RE: The Worst Advice

    GilaMonster (7/11/2009)


    Lynn Pettis (7/11/2009)


    Partly disagree here. True, you should just answer never, ever use a cursor, but ....

    Is there a 'not' missing from that sentence?

    Yes there is. I'll...

  • RE: Scripting from Management Studio

    Florian Reischl (7/11/2009)


    It depends on your scripting options. If you select option "Include IF NOT EXISTS" you get this syntax because there is no other way to handle this for...

  • RE: The Worst Advice

    rf44 (7/11/2009)


    Answering "never, ever use a cursor" or something equally smart.

    The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked for...

  • RE: SQL Server 2008 Express/Advanced or SQL Server 2005 Standard

    If the projects are for yourself and friends, I'd go wih express. I'd even say express if it would be a desktop app you might consider selling commercially. ...

  • RE: Order of tables in a from line

    Okay, but I won't know until Monday evening. I should hopefully be spending the day out on the pitch officiating games at the PPI up at the USAFA.

  • RE: Create database using Backup file

    First, if there were two differential backups taken after the last full backup you are restoring and you want the data as current as the second differential, you only need...

  • RE: SQL script to Restore a DB to standard starting point for Test purposes

    Staffed?? There really isn't a whole lot of staff on SSC. Most of us give of our time voluntarily as many of us have our own full time...

  • RE: regarding database

    What to do you mean? Question is a bit vaque and I'm not sure what you are asking.

  • RE: Scripting from Management Studio

    You can accomplish this by highlighting the views you want to script in the Object Explorer Details tab, then right clicking on one of the veiws and selecting the option...

  • RE: DAC Error for Express

    What is error you are getting and from where are you attempting to make the DAC connect?

  • RE: Tracking down culprit that dropped a trigger in SQL 2000

    Once the trace is setup, all the startup stored procedure needs to do is start the trace. It shouldn't have to be setup every time the server is restarted....

  • RE: High memory usage in sql server 2005

    Steve Jones - Editor (7/10/2009)


    Any logic for leaving 4GB for the OS? Does it need it in 64bit?

    Or would you be OK running to 30GB for SQL?

    I'll have to research...

Viewing 15 posts - 19,786 through 19,800 (of 26,490 total)