Forum Replies Created

Viewing 15 posts - 17,056 through 17,070 (of 59,067 total)

  • 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

  • RE: query to update a table with XML value

    fafful (8/10/2016)

    I have 2 tables:

    Table_A (InsuranceNo, JobNo,Processed) values('Anton1',NULL),('Jason1', NULL),('Citirus2',NULL)

    Table_B (InsuranceNo, XmlResponse)

    values ('Anton1','<Boot><Jobs><Job_entered jobno="2122" logged_info="Job number 2122">2122</Job_entered></Jobs></Boot>'),

    ('Citirus2','<Boot><ErrorDetails> a problem occured with data </ErrorDetails></Boot>')

    Question:

    I want to update Table_A Jobno column with the...

    --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 8:24 am

    #1894796

  • RE: How do I transpose rows to columns?

    For more information and a better understanding of the method that Orlando is using, please see the following article.

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    --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 8:11 am

    #1894792

  • RE: power script to find backup status in sql server

    naren.ece2012 (8/10/2016)

    Hi All,

    I need a power-shell script to obtain the following information Name of the database , LastBackupDate of the database and this information should be sent via an email...

    --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 8:06 am

    #1894788

  • RE: Need to load date from datepart from a table to a file

    Ed Wagner (8/10/2016)

    The CONVERT function supports the format you want to use. Just apply it to a column instead.

    SELECT CONVERT(Varchar(10), GETDATE(), 110);

    Do T-SQL functions actually work inn SSIS, Ed?...

    --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 7:57 am

    #1894783

Viewing 15 posts - 17,056 through 17,070 (of 59,067 total)