Forum Replies Created

Viewing 15 posts - 18,001 through 18,015 (of 59,069 total)

  • RE: Need help with datatype Time conversion

    Luis Cazares (3/28/2016)

    I'm guessing that Jeff is thinking on taking a similar path to this, but wants to be sure about the possible restrictions.

    Exactly. And, there's some pretty nifty...

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

    March 28, 2016 at 8:31 am

    #1867983

  • RE: Protecting sa

    Steve Jones - SSC Editor (3/28/2016)

    sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try and prevent...

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

    March 28, 2016 at 8:25 am

    #1867980

  • RE: Query Performance Issue with multiple unions and a view

    chandan_jha18 (3/28/2016)

    Dear All,

    Today while running the procedure in its original form, which takes around 10 seconds to output 100 rows for a particular set of parameters, I opened a new...

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

    March 28, 2016 at 7:42 am

    #1867967

  • RE: Query Performance Issue with multiple unions and a view

    chandan_jha18 (3/21/2016)

    Thanks Lowell. The NULL and the Or clause are business rules so won't be able to find my way around that.

    Went back through the posts on this thread 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)

    March 28, 2016 at 7:34 am

    #1867963

  • RE: Finding months in incremental fashion

    frdrckmitchell7 (10/8/2014)

    Hi people

    First of all thank you for your help yesterday; however, I would like to continue with the problem that I have:

    This is what I have thus far:

    SELECT CAST(CONVERT(VARCHAR(8),...

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

    March 28, 2016 at 12:57 am

    #1867914

  • RE: Need help with datatype Time conversion

    Mac1986 (3/26/2016)

    Hello All,

    I have source table with column nvarchar(20). the data looks like below.

    Duration

    120:06:31.150

    120:06:31.165

    238:21:19.875

    266:45:41.472

    287:03:25.184

    I need to dump it into destination and i do...

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

    March 27, 2016 at 6:00 pm

    #1867908

  • RE: On formatting SQL code

    diamondgm (3/26/2016)

    diamondgm (3/26/2016)

    The results should be visible here

    If the BI gods do their thing, the report should update hourly

    You should also be able to download the data by clicking on...

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

    March 27, 2016 at 12:03 pm

    #1867891

  • RE: Scalar function

    Sachin Nandanwar (3/26/2016)

    ALTER FUNCTION [dbo].[Getgrnqty_test2] (@ItemCode VARCHAR(10))

    RETURNS TABLE

    AS

    BEGIN

    RETURN

    (SELECT S1.divisionid,

    ...

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

    March 26, 2016 at 10:09 am

    #1867859

  • RE: On formatting SQL code

    diamondgm (3/26/2016)

    JBrosch (3/26/2016)

    How about a simple SurveyMonkey survey on this? ... I would curious to see the results 5 = heavily structured and enforced to 1 = free form -...

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

    March 26, 2016 at 9:38 am

    #1867855

  • RE: How to avoid Data Purging?

    sram24_mca (12/1/2015)

    Frequently we are running the Data Purging in our production server. How to avoid this to improve the performance. Is there any better solution for resolving the problem

    Regards,

    Ram

    What...

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

    March 25, 2016 at 5:11 pm

    #1867821

  • RE: On formatting SQL code

    I'm one of those folks that will spend a little time doing vertical and horizontal alignment in my code. Since I'm very used to it, it takes me almost...

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

    March 25, 2016 at 5:07 pm

    #1867820

  • RE: Protecting sa

    It's not just "sa" that needs protecting... it's ANY AND ALL logins, especially those with SysAdmin or Control Server privs. There absolutely must be good password policies setup 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)

    March 25, 2016 at 4:46 pm

    #1867816

  • RE: xp_delete_file does not remove older backup files

    Heh... it's funny that you brought this up. I've found and deleted more than 60,000 such files on one of my legacy servers. It believe it may be...

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

    March 25, 2016 at 4:43 pm

    #1867815

  • RE: SSIS on a dedicated server?

    sqlfriends (3/24/2016)

    Even this some nights the ETL runs use a lot CPU and crash the server.

    It's likely NOT going to help to move to separate server if that's what's going...

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

    March 25, 2016 at 8:11 am

    #1867744

  • RE: Tree structure of parent child

    You're welcome. Thank you for the feedback. The question now is... do you understand it so that you can 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)

    March 25, 2016 at 7:26 am

    #1867737

Viewing 15 posts - 18,001 through 18,015 (of 59,069 total)