Forum Replies Created

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

  • RE: How Do You Find a DBA?

    Core6430 (12/24/2013)

    I dislike using recruiters because getting the company name is like pulling teeth, and finding a half way decent one is a monumental feat. I once had one insist...

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

    #1675814

  • RE: Is sp_executesql reliable?

    Ah... while I agree with being paranoid about the use of dynamic SQL, it should not be something that keeps you from using it when necessary. It's an incredibly...

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

    #1675812

  • RE: Maintanance

    ramana3327 (12/24/2013)

    How to check all the maintenance plans at same time. I want to test the migration so I saw that we have see all maintenance plans and take scripts...

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

    #1675807

  • 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

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