Forum Replies Created

Viewing 15 posts - 53,551 through 53,565 (of 59,098 total)

  • RE: SELECT INTO

    Heh... thanks, Donald... I just knew there had to be something else... maybe even some DELETE triggers somewhere in there that no longer fire due to the Truncate...

    Anyway, thanks for...

    --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 19, 2007 at 6:48 am

    #761373

  • RE: Different date format in different tables.

    Ashwin M N (12/18/2007)

    I want to make clear about what my application developer wants.

    create table test1 (A1 int identity(1,1),A2 datetime)

    insert into test1(A2) select 19-12-2007

    create table test2 (A1 int identity(1,1),A2 datetime)

    insert...

    --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 19, 2007 at 6:46 am

    #761372

  • RE: Dynamic Proc

    Mike Levan (12/18/2007)

    when i tried doing this

    select startDate from tblemp where startDate between '1/1/2006' and '12/31/2006'

    i dont get that date range, why?

    startdate is varchar(100), I Cant change that in 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)

    December 19, 2007 at 6:32 am

    #761368

  • RE: Concatenation function

    Sure... with what?

    --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 18, 2007 at 5:22 pm

    #761270

  • RE: update only one field in a table with concatenation

    David,

    Now, be gentle with me... just now starting to get my feet wet on 2k5... 😉

    ...since the following two queries return the identical result set, why did you include "STUFF"...

    --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 18, 2007 at 4:44 pm

    #761268

  • RE: The simple ones really stump me...

    Unlike Oracle or other RDBMS's, you can do this in SQL Server...

    UPDATE CEM_smcsAssignments

    SET MGR = a.MGR

    FROM #ADD 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)

    December 18, 2007 at 3:47 pm

    #761257

  • RE: Report rendering time too long

    Why might using a parameter slow down a basic report?

    Dunno about most of your problems (although sub-queries could be a huge problem if they are actually correlated subqueries), but some...

    --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 18, 2007 at 3:43 pm

    #761256

  • RE: how to tune this query

    Are any of the items in the FROM clause actually views instead of tables?

    --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 18, 2007 at 3:05 pm

    #761243

  • RE: Concatenation function

    I want to create a function for which I pass ID, placeholder, type; it should give me a concatenated names.

    Why? Basically, this is a form of "Death-by-SQL"... where are...

    --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 18, 2007 at 3:02 pm

    #761242

  • RE: Log growth problem

    You don't really want to have it reclaim space automatically... causes too much fragmentation over time...

    You need to find out what's making it grow to 42Gig... that's step 1...

    --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 18, 2007 at 2:55 pm

    #761241

  • RE: SELECT INTO

    10 hours to 15 minutes? Heh... I like SELECT/INTO a lot but I've not seen that type of performance gain just by switching like that before... Are you sure...

    --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 18, 2007 at 2:52 pm

    #761240

  • RE: Problem Extracting Data from Flat File

    I load flat files that have many different row types. Fortunately, they're identified by a key in the file. I just load the whole shootin' match into 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)

    December 18, 2007 at 2:45 pm

    #761237

  • RE: Log growth problem

    Was it sitting at 42GB a week ago with only .5% used as it was this morning? If so, I think you could probably safely shrink the log file...

    --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 18, 2007 at 12:36 pm

    #761202

  • RE: Dynamic Proc

    What is the datatype of the JobDate column and what does the ChangeDate function return as a datatype?

    --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 18, 2007 at 11:20 am

    #761162

  • RE: concatenation problem

    Jeff - it's a sequential file setup. look at the multiple segments (1 relates to the next "2" by previous.col3=current.col2).

    Heh... I'm getting old... I was looking at trying 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)

    December 18, 2007 at 11:14 am

    #761156

Viewing 15 posts - 53,551 through 53,565 (of 59,098 total)