Forum Replies Created

Viewing 15 posts - 27,286 through 27,300 (of 59,101 total)

  • RE: Flatten a one to many?

    kpwimberger (3/7/2013)

    I have been reading the article and am trying to apply that fix now. I thought the additional data I sent would have helped. I may be able 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)

    March 7, 2013 at 4:39 pm

    #1594750

  • RE: Are the posted questions getting worse?

    Revenant (3/4/2013)

    Evil Kraig F (3/4/2013)

    Revenant (3/4/2013)

    I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing...

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

    March 7, 2013 at 4:22 pm

    #1594744

  • RE: query performance

    TheSQLGuru (3/6/2013)

    SELECT CASE WHEN number%3 = 0 THEN 0 ELSE number END AS a

    INTO #tmp

    FROM kgbtools.dbo.BigNumbers

    (100000 row(s) affected)

    CREATE CLUSTERED INDEX idx ON #tmp (a)

    DBCC freeproccache

    go

    SELECT *

    FROM...

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

    March 7, 2013 at 6:46 am

    #1594422

  • RE: query performance

    TheSQLGuru (3/6/2013)

    Jeff Moden (3/6/2013)

    TheSQLGuru (3/6/2013)

    The UDFs are a problem if for no other reason than the optimizer cannot know what is coming out of them, thus it will get inaccurate...

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

    March 7, 2013 at 6:41 am

    #1594419

  • RE: Hierarchy example - Ken Henderson's book - not working

    Ok. I'm totally confused as to what Ken was trying to demonstrate. Let's take his first query from your last post.

    select chartdepth=1, employee=o2.employee, supervisor=o1.employee

    into #org_chart

    from staff o1 inner...

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

    March 6, 2013 at 8:30 pm

    #1594246

  • RE: Duties of a DBA

    sunny.tjk (3/6/2013)

    Could someone please brief me about the daily duties of a production support SQL Server DBA?

    There are dozens and dozens of articles on the subject. Please see my...

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

    March 6, 2013 at 4:45 pm

    #1594212

  • RE: query performance

    TheSQLGuru (3/6/2013)

    The UDFs are a problem if for no other reason than the optimizer cannot know what is coming out of them, thus it will get inaccurate estimates 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)

    March 6, 2013 at 2:59 pm

    #1594179

  • RE: query performance

    kk1173 (3/6/2013)

    I am sorry for not posting the performance problem in the recommended way.

    As Lynn mentioned, we still need to see the code for the function and the Actual...

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

    March 6, 2013 at 2:57 pm

    #1594176

  • RE: query performance

    kk1173 (3/5/2013)

    to give you an idea of type of queries that are being run

    SELECT minormkt

    ,Sum(admits) as 'Total Admits' ,Sum([days]) as 'Total Days' , sum(OppAdm) as 'Opp Adm'...

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

    March 6, 2013 at 7:36 am

    #1593960

  • RE: Working with SQL Server Recovery Models

    BWAAA-HAAAA!!!! I "hear" it every day. Just look at 50% of the posts on these and other forums. 😛

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

    March 6, 2013 at 7:17 am

    #1593938

  • RE: Hierarchy example - Ken Henderson's book - not working

    Ah...my apologies. I lost track of this thread. On my way to work. I'll try to post an example tonight.

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

    March 6, 2013 at 7:11 am

    #1593934

  • RE: query performance

    kk1173 (3/5/2013)

    I have the following questions

    1. What does SARGable mean?

    2. Wouldn't normalization decrease performance, since it would involve joining of multiple tables?

    3. Would partitioning the table help?

    Thanks

    1. Pretty much...

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

    March 5, 2013 at 12:40 pm

    #1593614

  • RE: How to maintain two digit values in sp?

    Nah... Developers got no money. They go after the company itself.

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

    March 5, 2013 at 10:15 am

    #1593554

  • RE: Working with SQL Server Recovery Models

    TravisDBA (3/5/2013)

    Not sure why an article had to be published on a basic topic like Recovery Models that can be easily gleaned from Books Online. 😀

    Because there's a lot of...

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

    March 5, 2013 at 10:12 am

    #1593553

  • RE: 6 places after decimal without rounding

    Sergiy (3/4/2013)

    Not sure such a change in the formula will add any accuracy.

    SUM will keep the 6 digits precision, while division will use implicit conversion to FLOAT before and implicit...

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

    March 5, 2013 at 7:51 am

    #1593485

Viewing 15 posts - 27,286 through 27,300 (of 59,101 total)