Forum Replies Created

Viewing 15 posts - 19,201 through 19,215 (of 59,072 total)

  • RE: Do You Have Scary Code?

    Gary Varga (11/10/2015)

    Jeff Moden (11/10/2015)

    Gary Varga (11/10/2015)

    I joined a project part way though and got ridiculed the week when I added the first unit test project to the solution. It...

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

    November 10, 2015 at 6:52 pm

    #1839018

  • RE: Do You Have Scary Code?

    Eric M Russell (11/10/2015)

    A foolish man builds his business on top of a million lines of source code.

    Hmmm.... wonder how much code Google or Ebay has.

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

    November 10, 2015 at 6:46 pm

    #1839016

  • RE: Question for All DBAs (What can I learn to enahnce my career?)

    MadAdmin (11/10/2015)

    Favorite Quotes:

    "Has anyone ever told you that a query you have written runs too fast?" - Dwain Camps - 6 Mar 2014

    Yes.

    Because the DB was then able to successfully...

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

    November 10, 2015 at 6:39 pm

    #1839015

  • RE: Do You Have Scary Code?

    GilaMonster (11/10/2015)

    I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching that.

    They've 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)

    November 10, 2015 at 9:19 am

    #1838897

  • RE: Delete Specific Record

    It's going to be a bit slow but something like the following will do it...

    SELECT columnlist

    FROM dbo.SomeTable

    WHERE (SomeColumn LIKE '%[^ ] [^ ]%' OR...

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

    November 10, 2015 at 6:35 am

    #1838820

  • RE: Querying Yesterday

    I don't recall all of the reasons/caveats offhand but I remember reading about it and then studying how it works. All I can remember is "OK then... there's 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)

    November 10, 2015 at 6:25 am

    #1838815

  • RE: Average and mean for months / weeks values

    Just to be sure, "average" and "mean" are the same thing.

    For averaging over months, a lot of people will design on of several types "floating" or "rolling" averages. 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)

    November 10, 2015 at 5:43 am

    #1838804

  • RE: Do You Have Scary Code?

    Gary Varga (11/10/2015)

    I joined a project part way though and got ridiculed the week when I added the first unit test project to the solution. It had 1 test.

    By then...

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

    November 10, 2015 at 5:36 am

    #1838803

  • RE: Cursors

    tt-615680 (11/10/2015)

    Thank you for your reply!

    I'm trying to get some information on permissions on each databases on the server but I'm trying to get a way of retrieving the information...

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

    November 10, 2015 at 5:21 am

    #1838800

  • RE: Transaction Log space issue

    jdbrown239 (11/9/2015)

    Hello

    I have a very large table (600,000,000 rows) on which I am trying to rebuild each index.

    Every time I try the log file runs out of space. Log...

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

    November 9, 2015 at 5:15 pm

    #1838733

  • RE: Transaction Log space issue

    have2much (11/9/2015)

    If you need to rebuild all indexes on a table, why don't you create new table and port data to new table in batches to limit log file growth.

    1....

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

    November 9, 2015 at 5:13 pm

    #1838732

  • RE: Transaction Log space issue

    Jacob Wilkins (11/9/2015)

    Keep in mind sp_spaceused doesn't report the size of a clustered index as part of "index_size". If the table in question has (is) a clustered index, and you're...

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

    November 9, 2015 at 5:09 pm

    #1838731

  • RE: Split time span into multiple records

    Just to share a warning... run the following and see what's wrong in the original query...

    SELECT CAST('2015-09-01 23:59:59.999' AS DATETIME);

    You shouldn't try to "hit the mark" on the end...

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

    November 9, 2015 at 5:03 pm

    #1838730

  • RE: Need help to run a Powershell from SQL Server

    Shawn Melton (11/9/2015)

    What is the error?

    ... and on which box is the "D:" drive?

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

    November 9, 2015 at 4:46 pm

    #1838727

  • RE: SSMS does not see my NAS

    I wouldn't remove it. It's saying the drive is already mapped. The question is, why it would appear otherwise.

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

    November 9, 2015 at 4:45 pm

    #1838726

Viewing 15 posts - 19,201 through 19,215 (of 59,072 total)