Forum Replies Created

Viewing 15 posts - 53,341 through 53,355 (of 59,072 total)

  • RE: Formatted Date in Default Contstraint

    Always a pleasure, MrPoleCat... and thanks for the feedback.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 11:04 am

    #763035

  • RE: Bulk Insert

    Something had to have changed in the environment... for example, the login that SQL Server uses to start services... it may have been changed permission wise on the Windows Server...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:57 am

    #763032

  • RE: Dead lock issue

    You haven't mentioned whether or not you're using an explicit transaction around all of those inserts and selects... that would be a real big cause of the deadlocks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:55 am

    #763031

  • RE: major production issue

    You might want to take smaller bites when inserting, as well. Insert a couple of hundred thousand using a control (ugh!) loop.

    If the data is being inserted from, say,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:49 am

    #763029

  • RE: Using Code posted in these forums

    Until they fix it, there's a work around...

    1. Put your cursor one line above the code box.

    2. Click and drag to one line below the code box.

    3. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:46 am

    #763027

  • RE: Formatted Date in Default Contstraint

    Heh... understood... I still kick myself for some of the things I've done to a database in past lives 😀

    Wouldn't really be an extra column and no tradeoff that I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:42 am

    #763025

  • RE: Formatted Date in Default Contstraint

    I'd still be tempted to make the formatting in a calculated column for the app so I could easily create reports like "How many emails did we send today?". ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 10:01 am

    #763010

  • RE: The December Energy Update

    My problem with a mega-watt satilite would be that some idiot would figure out a way to turn it into a beam weapon. ION drive? Way cool application...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:54 am

    #763009

  • RE: The SQL * Wildcard

    Always select just the columns that you need.

    That goes without saying for the most part. But, again, I want to remind everyone that the OP said that Microsoft said...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:22 am

    #762990

  • RE: Formatted Date in Default Contstraint

    You bet...

    Personally, what I'd rather see is a real DATETIME column and a CALCULATED column to provide the varchar version that the GUI needs. Somewhere down the line,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:20 am

    #762989

  • RE: Update Rowcount

    JohnG (12/27/2007)

    I agree with Nebojsa.

    Use a return (OUTPUT) parameter as it is a much cleaner solution. You're calling a procedure and not a function. In coding, procedures are...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:13 am

    #762985

  • RE: Stored Proc passing Table Name Fails - Help

    Heh... dang it... I keep forgetting this is an SQL Server 2k5 forum! Thanks John.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:08 am

    #762980

  • RE: Rows to Columns

    I saw that PIVOT is much faster than doing subqueries or CASE statements to transform aggregated data to columns

    Jacob, if you have an example of that and a smattering of...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 9:07 am

    #762979

  • RE: How can I create a clone of a database on the fly?

    This needs to be run on-the-fly, by non-technical end users, maybe 5-10 times per day.

    The newly-created database needs to be dropped after the routine is finished.

    Why is this being done?...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 8:43 am

    #762966

  • RE: Rows to Columns

    Oh my... we've gone from using a new function that (apparently) can't do the job, to using a Cursor...

    Heh... Let's get back to the basics folks!

    Consider the following PIVOT...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 27, 2007 at 8:20 am

    #762953

Viewing 15 posts - 53,341 through 53,355 (of 59,072 total)