Forum Replies Created

Viewing 15 posts - 34,771 through 34,785 (of 59,099 total)

  • RE: Is Microsoft neglecting SMO?

    Phil Factor (3/6/2011)

    Maybe we should turn it around and list all the things that they spend way too much time and effort on, Jeff.

    Good idea, Phil, except that list...

    --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, 2011 at 1:16 pm

    #1295149

  • RE: Execute stored procedure

    Deepthy (3/6/2011)

    Hi all,

    I want to execute the stored procedure usp_myproc(@versionid int,@stationname@ varchar(100),@enddate date,@reason varchar(100)) by passing 200 different values of @versionid and @stationname while the @enddate and 'reason are always...

    --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, 2011 at 12:58 pm

    #1295145

  • RE: question about update record

    update Info set header=ISNULL(@hea,header),content=ISNULL(@cont,content),image=(@im,image)

    --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, 2011 at 12:56 pm

    #1295144

  • RE: SQL Query - Query for various attributes problem ...

    bdaviduck (3/6/2011)

    Yes -- as a programmer, it was natural to think of a solution using bitmasks; and it actually works fairly well on SQL server -- however, I am open...

    --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, 2011 at 12:50 pm

    #1295142

  • RE: Concatenating Rows

    Robert Bourdeau (3/4/2011)

    It is a shame that TSQL lacks the CONNECT BY clause that is available with Oracle. All these complex solutions could be eliminated for many classes of row-joining...

    --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, 2011 at 11:54 am

    #1295139

  • RE: Concatenating Rows

    Jeff Moden (10/18/2009)

    And here's a function for items that don't exceed 8K...

    --===== Create a function that uses VARCHAR(8000) with a DUPE Eliminator

    CREATE FUNCTION dbo.Concat8KTestDupElim

    ...

    --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, 2011 at 11:51 am

    #1295138

  • RE: Concatenating Rows

    Carlo Romagnano (10/17/2009)

    msam77-503326 (10/15/2009)

    Below is simple sql that does that

    declare @res varchar(Max)

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

    from

    (

    select 'Apple'...

    --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, 2011 at 11:49 am

    #1295136

  • RE: Concatenating Rows

    burtsev (3/4/2011)

    bnordberg (10/14/2009)

    I recently had to concatenate ~1.5 billion rows of text (average length of 110 characters). These were medical notes where each line was a sepearte row. I tested...

    --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, 2011 at 11:47 am

    #1295134

  • RE: Concatenating Rows

    kaplan.dani (3/4/2011)

    I think this (using a cursor to iterate on the list) is the most reasonable solution for the newbie sql dveloper.

    Is there a performance issue in this way ?

    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)

    March 6, 2011 at 11:42 am

    #1295132

  • RE: Concatenating Rows

    RHaverty 8478 (3/4/2011)

    My solution where I posted the coalesce solution will eat up a cursor on performance. Another better solution than using a cursor is:

    But, it's not. It...

    --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, 2011 at 11:39 am

    #1295131

  • RE: Concatenating Rows

    vkhabas (3/4/2011)

    Sorry Guys, as I remember the CTE recursion works with depth <= 70

    Actually, the default for the number of resursions is 100. The max explicit size is 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)

    March 6, 2011 at 11:37 am

    #1295130

  • RE: Concatenating Rows

    a.rajmane (3/6/2011)

    Another simple way of doing this ... see the example at http://www.sqlsuperfast.com/post/2011/02/17/T-SQL-to-Convert-rows-into-single-column.aspx

    You had a bad link in your post. I fixed it in the above quote.

    Both of those...

    --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, 2011 at 11:34 am

    #1295129

  • RE: SP4 on 2005 Standars edtition (32 bits)

    Derrick Smith (11/15/2010)

    All service packs for microsoft products are cumulative - you only need to install the latest one.

    That said...Isn't SP4 still in CTP? I wouldn't use that until it's...

    --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, 2011 at 12:16 am

    #1295066

  • RE: SLA Contracts

    A lot of folks on this thread keep talking about "HUGE COSTS". Why do you people think that there are such huge costs involved for simple data safety? ...

    --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, 2011 at 9:05 pm

    #1295063

  • RE: SQL Query - Query for various attributes problem ...

    EXCELLENT POST and VERY interesting subject! Can you post the table and bitmask-definition for your proposed bitmask solution for the examples you have in your original posts?

    Bitmasks are very...

    --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, 2011 at 5:39 pm

    #1295057

Viewing 15 posts - 34,771 through 34,785 (of 59,099 total)