Forum Replies Created

Viewing 15 posts - 41,506 through 41,520 (of 59,067 total)

  • RE: improving performance of stored procedure

    One of the problems that I see in the view is that the same data is being SUMmed over and over and over. Not sure I can figure 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)

    October 16, 2009 at 5:16 pm

    #1067263

  • RE: Afraid of Help

    It's a tough call...

    First, most people don't even know they need help. That's why Microsoft put Cursors, While Loops, CLR's and other forms of RBAR in SQL Server......

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

    October 16, 2009 at 4:45 pm

    #1067260

  • RE: Slow Query

    Tara-1044200 (10/16/2009)

    select distinct a.empid

    from ViewEmpployee a inner join #Empdates b on a.empid=b.empid,#researchtab

    where EmmJobCode in( '435','767','974') or

    (Job1 = '5' or Job2 = '5'or Job3 ='5' or Job4 = '5' or Job5...

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

    October 16, 2009 at 2:12 pm

    #1067188

  • RE: TSQL Question about getting data

    Brad,

    This appears to be a "simple" running total problem. If you'd take the time to format the data in a readily consumable format along with a CREATE TABLE statement,...

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

    October 16, 2009 at 1:53 pm

    #1067171

  • RE: date columns based query

    sql2000-915039 (10/16/2009)

    I have a datecolumn in this format 2009-10-15 16:57:00 in a table.

    I need to write a query which takes this date column values and classifies rows based 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)

    October 16, 2009 at 1:46 pm

    #1067163

  • RE: Poor Man's Enterprise Feature - Lock Pages in Memory

    Heh... wouldn't a reasonable alternative be to only have SQL Server on the SQL Server box? 😉

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

    October 16, 2009 at 1:09 pm

    #1067140

  • RE: Concatenating Rows

    sonphan11 (10/16/2009)

    This method:

    DECLARE @var varchar(8000)

    SET @var = ''

    SELECT @var = @var + FieldName + '/'

    FROM Table

    SELECT @var

    works fine for even multiple entities, just create a view first. I've been using...

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

    October 16, 2009 at 12:50 pm

    #1067121

  • RE: query to modify

    I don't know folks... don't kill me for this but he is a newbie, he asked very politely, it wasn't one of those "URGENT, URGENT!!!!" requests that we frequently see,...

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

    October 16, 2009 at 9:04 am

    #1066970

  • RE: Concatenating Rows

    msam77-503326 (10/15/2009)

    Below is simple sql that does that

    declare @res varchar(Max)

    select @res = coalesce(@res + ',', '') + [name]

    from

    (

    select 'Apple' as...

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

    October 15, 2009 at 4:14 pm

    #1066621

  • RE: Concatenating Rows

    Outstanding, Rob! I love it when a plan comes together. According to your timings, the XML beat the tar out of the CLR and the simple 8k function...

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

    October 15, 2009 at 4:09 pm

    #1066619

  • RE: Are the posted questions getting worse?

    P Jones (10/15/2009)

    BTW if it's kilt Wednesday at Pass who's entitled to wear which tartan?

    Hunting Stewart for Jeff Moden, master of the Pork Chop weapon?

    Heh... two things no one...

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

    October 15, 2009 at 9:05 am

    #1066327

  • RE: Are the posted questions getting worse?

    Elliott W (10/14/2009)

    While some of the questions have been gems.. Some of the responses, mostly from the inexperienced, are nothing shy of wild guesses based on nothing, let alone...

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

    October 15, 2009 at 8:59 am

    #1066323

  • RE: Concatenating Rows

    Rob Fisk (10/15/2009)

    Jeff. Once again, greet work on the performance testing.

    I did a wee compare last night but do not have the results due to a bit of a power...

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

    October 15, 2009 at 8:02 am

    #1066279

  • RE: Concatenating Rows

    Rob Fisk (10/15/2009)

    You are NOT using coalesce to concatenate.

    in the example above, coalesce is used to remove NULL entries.

    The below works just the same using that example:

    DECLARE @Name AS varchar(Max);

    SELECT...

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

    October 15, 2009 at 7:40 am

    #1066259

  • RE: Concatenating Rows

    Andy DBA (10/14/2009)

    Jeff Moden

    Also, I noticed the varchar(5) type you used in your " XML TYPE solution" truncated the results. But, when I tested with varchar(max) or varchar(2000) 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)

    October 15, 2009 at 7:35 am

    #1066253

Viewing 15 posts - 41,506 through 41,520 (of 59,067 total)