Forum Replies Created

Viewing 15 posts - 47,971 through 47,985 (of 59,099 total)

  • RE: Appending numbers and text

    Franco_1 (10/3/2008)

    I have to concatenate fields from a table into on huge column in another table. Problem is some of the data from some of the columns are varchar, float...

    --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 3, 2008 at 8:05 pm

    #880779

  • RE: Does the physical position of FK columns matter?

    And, yet, we so no testing nor references to Microsoft articles on the subject... does anyone have proof one way or the other? 😉

    --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 3, 2008 at 8:01 pm

    #880777

  • RE: Re: User defined functions

    jlp3630 (10/3/2008)

    Are there any disadvantages to using t-sql user defined functions? From a coding/maintainability perspective, I prefer to use them. However, I wasn't sure if I was taking a performance...

    --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 3, 2008 at 7:51 pm

    #880776

  • RE: Re: User defined functions

    jeremiah.peschka (10/3/2008)

    Likewise, CLR functions have an even larger performance advantage over T-SQL functions for complex computation, string manipulation, and business logic.

    With the exception of RegExReplace, many of us have been...

    --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 3, 2008 at 7:48 pm

    #880773

  • RE: I need the number of connections for a specific database

    lcjohnson (10/3/2008)

    I found the script to kill the users. Thanks.

    Use with great caution! If you hit the wrong SPID, you can tank the server or some critical poorly written...

    --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 3, 2008 at 7:45 pm

    #880771

  • RE: Problem with Tsql script

    Heh... You're all destroying the ability to produce an automated data dictionary for a database and none of you even bat an eyelash at that. :blink: Sure, 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)

    October 3, 2008 at 7:27 pm

    #880768

  • RE: Remove Duplicate Row

    Okidoki... first off, since you didn't provide any table creation scripts nor data population scripts, you have to understand that I've not tested this code. Please see the link...

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

    #880766

  • RE: Cross Tab query

    vidhyasudha (10/3/2008)

    HI Luke,

    Sorry for all the inconvenience caused.

    Tab1 structure

    Create Table Tab1

    (

    name varchar(25),

    description varchar(25),

    Category varchar(25)

    )

    Sample data for Tab1

    insert into tab1 (name,description,category) values ( 'caneditacc','editing','Acc')

    insert into tab1 (name,description,category) values ('candeleteacc','deleting','Acc')

    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)

    October 3, 2008 at 6:28 pm

    #880765

  • RE: Converting varchar to datetime

    There are a lot of things that will qualify as a date that will fail the conversion using date format 103. For example, 0 is a valid date. ...

    --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 3, 2008 at 6:19 pm

    #880762

  • RE: Development environment data refresh

    I don't personnally know how to do it, but the folks at my old shop did it quite easily. Apparently, certain SANs come with the ability to make snapshot...

    --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 3, 2008 at 6:06 pm

    #880760

  • RE: Performance improvement with BULK INSERT

    Yep... I absolutely agree with Richard that batch size is important... trying to import 20 million rows will drive the log file absolutely nuts if you don't do the Bulk...

    --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 3, 2008 at 5:59 pm

    #880758

  • RE: IF condition

    It doesn't need to be that complicated if you understand that NULL is NOT nothing and cannot be compared to using relational operators...

    IF (SELECT somecolumn FROM sometable) > ' '

    PRINT...

    --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 3, 2008 at 5:52 pm

    #880755

  • RE: Avoiding Curosr - Yet Another Situation

    Heh... if you think THAT was fast, wait until you run the code. First time I demo'd it on a million rows in front of a group of people,...

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

    #880751

  • RE: Query String passed to URL

    Jason Crider (10/3/2008)

    Third party wants that data sent to a URL in the form of a query string.

    So, create a chunk of code that will make a set of SELECT/UNION...

    --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 3, 2008 at 5:36 pm

    #880749

  • RE: Pull data from one Column for a report

    There's nothing there to relate state to county, etc, etc. Are the other columns in that table that might be used to do that?

    --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 3, 2008 at 5:22 pm

    #880745

Viewing 15 posts - 47,971 through 47,985 (of 59,099 total)