Forum Replies Created

Viewing 15 posts - 25,021 through 25,035 (of 59,099 total)

  • RE: Sound Matching and a Phonetic Toolkit

    AVB (12/24/2013)

    Jeff,

    I read the article. Much easier than writing a loop too. I'm not familiar with the FOR XML commands so I opted to do it a different way but...

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

    December 24, 2013 at 11:19 am

    #1675806

  • RE: Clustered Index Rebuild Space Requirements ?

    homebrew01 (12/24/2013)

    Thanks.

    It is a table in an archive database that is in simple recovery mode.

    The index itself is 1 or 2 gig. The database has 2 files (mdf & ndf),...

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

    December 24, 2013 at 10:58 am

    #1675805

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (12/24/2013)

    Merry Christmas to all of y'all.

    Peace on earth, goodwill to all peoples. Even those at whom Jeff would throw pork chops..

    🙂

    Perhaps...

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

    December 24, 2013 at 10:08 am

    #1675800

  • RE: Regarding table partition

    harita (12/23/2013)

    yes I created additional file groups

    Did your "Partition Schema" identify which file groups would be used for each partition?

    Also, why on this good green Earth did you pick an...

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

    December 23, 2013 at 1:49 pm

    #1675681

  • RE: Updating a Sequence Number with Order

    Thank you very much for the feedback.

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

    December 23, 2013 at 11:42 am

    #1675665

  • RE: select YearMonth only

    mattech06 (12/23/2013)

    cheers Jeff, it is a DATETIME column so I shall try your solutions now. Just a quick question would both examples SELECT any dates that fall with Jan 2013...

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

    December 23, 2013 at 9:37 am

    #1675644

  • RE: Issuing a kill command

    I would advise that killing a SPID should be considered a final and very desparate act because killing a SPID (it's documented on CONNECT as a major problem) will sometimes...

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

    December 23, 2013 at 8:44 am

    #1675636

  • RE: select YearMonth only

    Yes. 2013-Jan will AUTOMATICALLY convert to a DATETIME datatype if played against a DATETIME column. For example...

    SELECT CAST('2013-Jan' AS DATETIME)

    Will return 2013-01-01 as a DATETIME. Your...

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

    December 23, 2013 at 8:36 am

    #1675633

  • RE: Is a date within multiple date ranges

    Tamil Vengai (12/23/2013)

    try this...

    Declare @mydt datetime

    set @mydt='2012-02-01';

    select @mydt,Condition from #TestTable

    where Condition='Yes' and @mydt between StartDate and EndDate

    u can refer mr.jeff post for creating #TestTable...

    🙂

    That works great but 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)

    December 23, 2013 at 6:56 am

    #1675595

  • RE: Relationally Divided over EAV

    David.Poole (12/11/2013)

    To my mind the term "best practice" is intended to be "preferred common usage" to help newbies from straying into dangerous territory without appropriate skills/awareness. Stage one is...

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

    December 23, 2013 at 5:59 am

    #1675576

  • RE: Get data month to calander week

    Oh, be careful with that. The "week" datepart can change based on the setting of DATEFIRST. And, no... you shouldn't count on that setting.

    I'm on my way 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)

    December 23, 2013 at 5:45 am

    #1675567

  • RE: sum of columns based on new group

    ChrisM@Work (12/23/2013)

    Jeff Moden (12/23/2013)

    ChrisM@Work (12/23/2013)

    Isn't this all rather irrelevant though? The source table is denormalised - it contains two types of data, products and subproducts. The output contains two types...

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

    December 23, 2013 at 5:40 am

    #1675564

  • RE: It’s About the Journey, Not the Exam

    Gary Varga (12/23/2013)

    At the time I was working with a manager who was hiring and, therefore, trawling through a huge number of CVs and conducting a large number of interviews....

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

    December 23, 2013 at 5:32 am

    #1675559

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (12/23/2013)

    I've been having a strange problem for the last few days, roughly speaking internet access to USA sites has been almost impossible: average proportion of lost packets...

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

    December 23, 2013 at 5:20 am

    #1675554

  • RE: Will SQL Server 2014 Support to Read BLOB (Byte Array)

    yuvipoy (12/23/2013)

    David Burrows (12/19/2013)

    DECLARE @test varchar(max)

    SET @test = CHAR(1)+CHAR(87)+CHAR(179)

    SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)

    how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is 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)

    December 23, 2013 at 5:15 am

    #1675552

Viewing 15 posts - 25,021 through 25,035 (of 59,099 total)