Forum Replies Created

Viewing 15 posts - 22,231 through 22,245 (of 59,098 total)

  • RE: SELECT a String

    Seems to be a correct answer, as well. If it's not, let them know on that other 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)

    December 11, 2014 at 6:59 pm

    #1764255

  • RE: 42% of 100% taken in clustered index insert

    Grant Fritchey (12/2/2014)

    npranj (12/1/2014)

    Thanks Grant.

    The 42% cost is Clustered Index insert cost. There is one CI and 4 NCI on this table.

    All the other costs are from Index Seeks.

    Also,...

    --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 11, 2014 at 6:54 pm

    #1764254

  • RE: growth above normal log database!

    rmedeiros (12/11/2014)

    Dear changed the log full bank for simple did shrink and it worked,

    Thank you all for the help

    AND??? You do realize that you need to at least 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)

    December 11, 2014 at 4:59 pm

    #1764249

  • RE: Load Folder name and Images into SQL Tables

    robertdba (12/11/2014)

    Hello Jeff,

    Sorry for the late reply, too much snow up here in Canada and network issues.

    So I will test it now, but before I got a question for 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)

    December 11, 2014 at 11:39 am

    #1764179

  • RE: Space Problems

    M. Gamito (12/11/2014)

    Jeff Moden (12/11/2014)

    M. Gamito (12/11/2014)

    Hello.

    I'm having some problems with my database usage space.

    I have a database with atogrowth off and limited size to 150GB.

    When users try to import...

    --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 11, 2014 at 9:21 am

    #1764134

  • RE: Space Problems

    M. Gamito (12/11/2014)

    Hello.

    I'm having some problems with my database usage space.

    I have a database with atogrowth off and limited size to 150GB.

    When users try to import files, large databases 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)

    December 11, 2014 at 8:06 am

    #1764080

  • RE: Approaches for creating a test environment

    TerrenceTheCat (12/11/2014)

    Hi all,

    I am try to put together options in regard to creating a test environment for our Dynamics NAV system. The environment will be mainly used to test 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)

    December 11, 2014 at 8:01 am

    #1764075

  • RE: growth above normal log database!

    Jason-299789 (12/11/2014)

    Its not surprising if you are rebuilding the clustered index as well which will effectively rebuild the entire table via the TempDB, I'll take a stab in the dark...

    --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 11, 2014 at 7:50 am

    #1764071

  • RE: get full path from sys.xp_dirtree

    Still, it's a brilliantly simple solution and it does solve a very common problem without a trip to the Command Prompt. Well done, again!

    And, yeah, I agree. How...

    --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 11, 2014 at 7:46 am

    #1764070

  • RE: Cte for String in random order

    Two way street here. I know it' been several months but I'm still interested in why you needed to do this.

    --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 10, 2014 at 11:59 pm

    #1763954

  • RE: Trouble with SQL Timeouts

    mqbk (12/10/2014)

    I am having sporadic SQL timeout errors from on of my companies applications. The first time we have seen this was when our connections went over the default 100...

    --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 10, 2014 at 11:28 pm

    #1763951

  • RE: CPUU increase and database engine

    ramana3327 (12/10/2014)

    Hi,

    We are using Sql server 2008R2 and windows server 2008R2.

    To increase the vCPU for the server and the server need to be restarted.

    Do we need to shut down...

    --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 10, 2014 at 11:25 pm

    #1763950

  • RE: Filling gaps in date ranges

    Ah... sorry. I see what the difference is now.

    Kevin's answer uses Itzik Ben-Gan's "inline" version of a "Tally Table". It' sometimes a bit slower (and 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)

    December 10, 2014 at 11:16 pm

    #1763949

  • RE: get full path from sys.xp_dirtree

    Ah... Just a note. This DOES constitute a "Triangular Join", which can make things pretty slow unless you add some proper indexes. I ran it against C:\Windows 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)

    December 10, 2014 at 9:57 pm

    #1763947

  • RE: Pivoting hierarchial data

    Understood.

    Here's the concatenated ID's thing. The only thing that I needed to change in the original data is that the CEO cannot report to him/herself. The CEO reports...

    --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 10, 2014 at 9:50 pm

    #1763946

Viewing 15 posts - 22,231 through 22,245 (of 59,098 total)