Forum Replies Created

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

  • RE: Temp DB Best Practice

    aravind_0404 (7/15/2009)

    @free_mascot

    Thanks for the reply...The size of log file should be 20-25% of the whole Datafile or the striped ndf's.

    For TempDB, I'd say "neither". If you're migrating databases...

    --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 15, 2009 at 9:46 pm

    #1025457

  • RE: Temp DB Best Practice

    free_mascot (7/15/2009)

    Usually Log file is 20-25% of your datafile. But still it depends on the application you are running, frequency of T-log backup, using logspace at the time of maintenance...

    --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 15, 2009 at 9:43 pm

    #1025454

  • RE: How to reseed identities in all tables

    ahmad.ghazi (7/15/2009)

    Hi guys,

    I want to create a script to loop in all tables to reseed the identities in a specific database

    using:

    DBCC CHECKIDENT(‘TableName’, RESEED, current_table_ident + 1)

    How can i make...

    --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 15, 2009 at 9:39 pm

    #1025453

  • RE: Over-Engineering

    With the shrinkwrapped software and inhouse/3rd party code I've seen coming out lately, I'm pretty sure that over-engineering isn't a wide-spread problem. 😉

    --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 15, 2009 at 9:36 pm

    #1025452

  • RE: What SQL Server Sites do you use?

    Steve Jones - Editor (7/15/2009)

    That's one of the things I've been concerned about, as I agree with Jeff on Barry's posts.

    I wouldn't mind seeing some "voting" to help people decide...

    --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 15, 2009 at 11:55 am

    #1025258

  • RE: Help us tune a query

    Heh... correction! It looks like the updates may be on a timer... both new posts suddenly registered on the home page. Still, I wouldn't spend much more time...

    --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 15, 2009 at 8:51 am

    #1025118

  • RE: Help us tune a query

    Heh... well, that little test pretty much cinches things up. The addition of the post above didn't change my counts on the home page what-so-ever.... not even in 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)

    July 15, 2009 at 8:48 am

    #1025115

  • RE: Help us tune a query

    Just a test... please ignore this 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 15, 2009 at 8:40 am

    #1025103

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    It's just below the table definition. Scroll down the code block a couple of posts above and you should see them.

    Heh... thanks Mel... you're reading my mind 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)

    July 15, 2009 at 7:09 am

    #1025002

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    I don't understand the logic behind its selection of IX_UsersDisplayName when it does the join into the Users table. Perhaps I'm just totally misunderstanding how indexes work, 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)

    July 15, 2009 at 6:54 am

    #1024988

  • RE: Help us tune a query

    GilaMonster (7/15/2009)

    Jeff Moden (7/14/2009)

    Something else is going on as well. Look at the difference in durations on your machine compared to mine.

    Look at the difference in reads...

    --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 15, 2009 at 6:47 am

    #1024981

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    You should just be able to right-click and save as for the sqlplan. I'll attach a zipped version to this post as well, just to be on 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)

    July 15, 2009 at 6:42 am

    #1024973

  • RE: Help us tune a query

    Mel Harbour (7/15/2009)

    You should just be able to right-click and save as for the sqlplan. I'll attach a zipped version to this post as well, just to be on 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)

    July 15, 2009 at 6:38 am

    #1024970

  • RE: What SQL Server Sites do you use?

    RBarryYoung (6/17/2009)

    As long as I'm making lists, What, IMHO, did/does Not work:

    A) "Accepted" or "Answer" flags: It seems like such a good and obvious thing: flag which 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)

    July 15, 2009 at 6:23 am

    #1024955

  • RE: Help us tune a query

    Jeff Moden (7/15/2009)

    Mel Harbour (7/15/2009)

    Ok, I've run a modified version of Jeff's suggestion:

    Something sure is wrong... look at the difference between the CPU and the duration compared to my box.

    Something...

    --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 15, 2009 at 6:14 am

    #1024949

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