Forum Replies Created

Viewing 15 posts - 33,031 through 33,045 (of 59,099 total)

  • RE: indexing a converted datetime column

    opc.three (8/1/2011)

    Wow! Why introduce an indexed view here? The list is long of restrictions and limitations.

    As you said, "I'm just trying to solve the problem at hand." and protect...

    --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 1, 2011 at 6:37 am

    #1361502

  • RE: indexing a converted datetime column

    I believe you used the wrong column in your examples for this problem. If we're still talking about the original problem, then SomeDate in JBMTest is the notorious formatted...

    --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 1, 2011 at 6:30 am

    #1361497

  • RE: indexing a converted datetime column

    Eric, tell the folks who made the request that you need to make an alternate suggestion because of the dangers of users having access to formatted dates.

    Consider the following alternative...

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

    July 31, 2011 at 9:47 pm

    #1361351

  • RE: indexing a converted datetime column

    opc.three (7/31/2011)

    Jeff, you're entire post is predicated on the idea that the problem case can be changed.

    Heh... not quite. My entire post is predicated on the idea that I...

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

    July 31, 2011 at 9:15 pm

    #1361348

  • RE: TempDB growth oddity.....

    Barkingdog (7/31/2011)

    Interesting thoughts from everyone. Unfortunately the developer has modified the query so the original problem no longer exists. In other words I can't provide the needed execution plan. Sorry...

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

    July 31, 2011 at 8:43 pm

    #1361345

  • RE: How do i identify resources needed to defrag/rebuild indexes

    winston Smith (7/31/2011)

    great ideas there to start creation of a plan , thanks carlos.

    I would like to know if anyone has expiremented with the issues caused by online index...

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

    July 31, 2011 at 8:20 pm

    #1361343

  • RE: Are the posted questions getting worse?

    GilaMonster (7/31/2011)

    In other news... Anyone willing to read over an article on recovery models and make sure I haven't made any grievous errors?

    I can take a look.

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

    July 31, 2011 at 7:39 pm

    #1361342

  • RE: dynamic data types

    dardar4 (7/31/2011)

    Hi guys.

    as a newbie in sql world i have a small question.

    i need to make a new table in our DB and one of the columns suppose to hold...

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

    July 31, 2011 at 7:36 pm

    #1361341

  • RE: dynamic data types

    dardar4 (7/31/2011)

    thx for the reply.

    wasn't familiar with the BOL option.

    🙂

    Just in case you don't know it, "BOL" is short for "Books Online" and it's the help-system that comes with (or...

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

    July 31, 2011 at 7:31 pm

    #1361340

  • RE: xp_cmdshell help

    {edit} Never mind... misread the post.

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

    July 31, 2011 at 7:22 pm

    #1361338

  • RE: Need some help

    clarification (7/31/2011)

    please check and reply what does this SP do?

    This SP is scheduled to execute daily on one important database which users are performing lot of operations daily.

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

    July 31, 2011 at 6:59 pm

    #1361337

  • RE: binary tree calculation

    Gianluca Sartori (7/26/2011)

    In SQL Server 2008 you can use the HierarchyId datatype to store tree structures.

    @Gianluca,

    Since you brought it up, I have to ask... have you used the HierarchyID datatype...

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

    July 31, 2011 at 7:29 am

    #1361306

  • RE: binary tree calculation

    s.khann786 (7/31/2011)

    Dear Jeff,

    i want to calculate parents id which have both child left and right.

    this is my table.

    id, parentid, left_child, right_child

    1 1 ...

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

    July 31, 2011 at 7:24 am

    #1361305

  • RE: TempDB growth oddity.....

    TRACEY-320982 (7/30/2011)

    If it takes that amount of space and there more than one statement in a sp then issue a backup statement in between to backup the log provided you...

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

    July 30, 2011 at 10:22 pm

    #1361286

  • RE: binary tree calculation

    If it's a simple count of pairs you want, just look at your data for the answer. Just count all rows that have both a LeftID AND RightID greater...

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

    July 30, 2011 at 10:14 pm

    #1361285

Viewing 15 posts - 33,031 through 33,045 (of 59,099 total)