Forum Replies Created

Viewing 15 posts - 17,086 through 17,100 (of 59,101 total)

  • RE: SQL backup Script is appending instead of overwriting

    mwinn (8/11/2016)

    Thanks, I will try that, not sure why it worked for all these years prior to yesterday though.

    To be honest, it couldn't have UNLESS you changed the file name...

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

    August 11, 2016 at 11:05 pm

    #1895156

  • RE: Replace of isnull as 0 for dynamic pivot

    p.s. NEVER use that type of Dynamic SQL in anything that's public facing, especially where modeltrim_name (in this case) could be entered by users, because it IS susceptible to...

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

    August 11, 2016 at 10:49 pm

    #1895154

  • RE: Replace of isnull as 0 for dynamic pivot

    Here's the Dynamic CROSSTAB version. I believe you might find it a little easier to read, modify, and troubleshoot.

    --===== Local Variables

    DECLARE @sql ...

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

    August 11, 2016 at 10:40 pm

    #1895153

  • RE: Tablix assistance please!

    faulknerwilliam2 (8/11/2016)

    I am currently using SSRS 2008R2. This is the script I am using:

    SELECT

    a.name,

    DATENAME(M, a.Date) as Month,

    DATENAME(YEAR,a.Date) as Year,

    DATEPART(YYYY, a.Date) as...

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

    August 11, 2016 at 9:03 pm

    #1895149

  • RE: Credits and Debits

    jssashank (8/11/2016)

    Works like a Charm. Thanks a lot 🙂 you mind going over the logic once just for this one piece " FULL OUTER JOIN Credits c ON c.[from] <...

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

    August 11, 2016 at 8:50 pm

    #1895148

  • RE: Third Normal form & some related things

    Steven.Grzybowski (8/11/2016)

    With the third normal form, is there any kind of general "rule of thumb" For when you should or should not apply it? I understand that a lot...

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

    August 11, 2016 at 8:40 pm

    #1895145

  • RE: need to copy a 600 gig table

    Snargables (8/11/2016)

    What would be the best way to do this? The db is in simple mode. i need a copy format that doesnt write to trans log.

    Ideas?

    Where do you want...

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

    August 11, 2016 at 8:36 pm

    #1895144

  • RE: need to copy a 600 gig table

    Luis Cazares (8/11/2016)

    Everything that changes data in a database writes to trans log.

    You might have some options to copy the table, but answer Eirikur's questions so we can have more...

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

    August 11, 2016 at 8:29 pm

    #1895143

  • RE: Today's Random Word!

    TomThomson (8/11/2016)

    crookj (8/11/2016)

    Manic Star (8/11/2016)

    djj (8/11/2016)

    Ed Wagner (8/11/2016)

    Revenant (8/11/2016)

    whereisSQL? (8/11/2016)

    djj (8/11/2016)

    Ed Wagner (8/11/2016)

    Grumpy DBA (8/11/2016)

    Ed Wagner (8/11/2016)

    Ray K (8/10/2016)

    Ed Wagner (8/10/2016)

    Ray K (8/10/2016)

    Luis Cazares (8/10/2016)

    Emmet Brown

    Biff Tannen

    Butthead

    Beavis

    Mr. Anderson

    Agent Smith

    Neo

    Nemo

    Dory

    Fishy

    Fried

    Chicken

    Wings

    Paul

    Damascus

    Road

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

    August 11, 2016 at 8:24 pm

    #1895141

  • RE: Powershell scripts to take SQL SERVER HEALTH CHECK

    You don't need Powershell for this. Google for Brent Ozar's "sp_Blitz" and Adam Machanic's "sp_WhoIsActive".

    Just remember... if you can't write it, you might not be able to maintain 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)

    August 11, 2016 at 5:55 pm

    #1895135

  • RE: Restore 'WITH MOVE' without knowing filenames

    Clint-525719 (8/11/2016)

    I want to perform a restore using WITH MOVE to move the files to a new location. However, I currently do not know the logical or physical filenames....

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

    August 11, 2016 at 5:52 pm

    #1895134

  • RE: Mistakes Columbus made.

    ben.brugman (8/11/2016)

    Eric M Russell (8/11/2016)

    "If you break a few eggs, then make an omelet."

    Christopher Columbus,... challenges his critics to make an egg stand on its tip. After his challengers...

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

    August 11, 2016 at 8:11 am

    #1895001

  • RE: Substring from RIGHT

    sjimmo (8/11/2016)

    Thanks Jeff. I was simply offering an alternative. Should have looked more closely at the dates. :hehe:

    Absolutely understood and alternatives are great. I appreciate your post even if...

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

    August 11, 2016 at 8:05 am

    #1894999

  • RE: Substring from RIGHT

    sjimmo (8/10/2016)

    DECLARE @valVARCHAR(30)

    SELECT @val = '9.0.0832.1032'

    SELECT @val

    SELECT SUBSTRING(@val, LEN(@val) - 6, 2)

    That will work but only if you only ever need the right 2 of the 3rd element and...

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

    August 10, 2016 at 6:52 pm

    #1894918

  • RE: query to update a table with XML value

    You'd have none of these problems if you stored the data as normalized data instead of XML. 😉

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

    August 10, 2016 at 6:14 pm

    #1894915

Viewing 15 posts - 17,086 through 17,100 (of 59,101 total)