Forum Replies Created

Viewing 15 posts - 33,316 through 33,330 (of 59,099 total)

  • RE: DELETING MILLIONS OF RECORDS FROM DATBASE

    damen.mis (7/8/2011)

    Syed Jahanzaib Bin hassan (6/30/2011)

    create procedure DeleteOlddata_SP

    as

    Begin

    Delete top(10000)

    from SC_SampledNumericDataFact_Table

    where DatetimeAdded<getdate()-180

    End

    And schedule this Store Procedure on the SQL Server Agent job with minimum interval of 15 mins,when you...

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

    July 9, 2011 at 5:24 pm

    #1350776

  • RE: Help getting rid of another cursor based query

    Tom Rippetoe (7/5/2011)

    Hi Jeff.

    Thanks for your suggestion; it definitly sent me down what seems to be the right path. Not every location is associated with every segment so a...

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

    July 9, 2011 at 4:31 pm

    #1350772

  • RE: Creating Columns from Rows - Variable Columns - Please Help

    {edit} Commented on wrong post...

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

    July 9, 2011 at 4:23 pm

    #1350771

  • RE: Combining Multiple Records Into One

    sdownen05 (7/5/2011)

    To get the job done quickly, and since I am not worried about performance right now, I am going to go with pure T-SQL.

    Heh... famous last words. No...

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

    July 9, 2011 at 4:20 pm

    #1350769

  • RE: Same statements, different plans?

    opc.three (7/8/2011)

    Long term I definitely want to remove the local variable swapping I just added.

    Why? :blink: It works just fine the way you did it and it's a whole...

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

    July 9, 2011 at 4:51 am

    #1350723

  • RE: Capacity Planning for Databases

    The simplest, easiest, and, perhaps, the most accurate method is to determine the database size today and a month from now. Multiply the difference between those two numbers times...

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

    July 9, 2011 at 4:35 am

    #1350721

  • RE: XP_cmdshell DIR

    Deee -Daah! (7/8/2011)

    I guess if filedates and sizes are not required then /B (bare) switch will work just fine.;-)

    Otherwise, DIR does not have a switch that has the filedates, sizes...

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

    July 8, 2011 at 8:09 pm

    #1350706

  • RE: Handle NULLs

    Since the requirements are all over hell's half-acre, let's review.

    1. We have two tables which will ALWAYS have a corresponding row in the other table.

    2. If there 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)

    July 8, 2011 at 1:05 pm

    #1350603

  • RE: Handle NULLs

    opc.three (7/8/2011)

    Edit 7/8/2011 7:20 Mtn: corrected property of Jeff's rendition, it "cannot be ordered by column name"

    Any bets? 😉

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

    July 8, 2011 at 12:51 pm

    #1350592

  • RE: Handle NULLs

    mikes84 (7/8/2011)

    Jeff, I think your solution addresses requirement #1, but not #2, since it's ordering by hobby name alphabetically? Do you know how it could be modified to order in...

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

    July 8, 2011 at 12:46 pm

    #1350589

  • RE: Handle NULLs

    Nevyn (7/8/2011)

    Cool stuff, Jeff!

    So do you ever use PIVOT and/or UNPIVOT, or are workarounds almost always better/faster?

    I don't use PIVOT because Cross-Tabs are (usually) both faster and easier to read...

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

    July 8, 2011 at 12:39 pm

    #1350581

  • RE: Where Do You Go for Authoritative SQL Server Best Practices?

    John Neville (7/8/2011)

    Suppose the bosses are screaming and jobs are on the line (or your reputation as a miracle-worker is being questioned) - do you test less thoroughly if you...

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

    July 8, 2011 at 7:54 am

    #1350362

  • RE: XP_cmdshell DIR

    Deee -Daah! (7/7/2011)

    DIR C:\temp /s >gt list.txt does not give you the fullpath of the files. The output looks more like this:

    Directory of C:\temp\test1\test2

    and then followed by...

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

    July 8, 2011 at 7:41 am

    #1350353

  • RE: Mortgage amortization table

    Greg,

    Did you change ALL the variables to DECIMAL??? Even the "period" related INTs?

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

    July 8, 2011 at 7:22 am

    #1350343

  • RE: Mortgage amortization table

    Greg Snidow (7/6/2011)

    Well, now I think the bankers and old ladies feathers will really be ruffled. I tried DECIMAL(28,18) and now I'm left with a positive balance of 35.991877150516022430....

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

    July 8, 2011 at 7:16 am

    #1350339

Viewing 15 posts - 33,316 through 33,330 (of 59,099 total)