Forum Replies Created

Viewing 15 posts - 41,986 through 42,000 (of 59,098 total)

  • RE: high CPU usage

    chidev (9/11/2009)

    At the same time, another process (stored proc) is selecting millions of records and inserting to a temp table to do calculations.

    Post the code and let's take a look....

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

    September 11, 2009 at 8:49 pm

    #1052632

  • RE: SELECT * versus SELECT 1 when using EXISTS

    I agree. I also agree with very specifically with what Adam said. Even if the pros say something, you should always test it yourself. The reason is...

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

    September 11, 2009 at 8:45 pm

    #1052631

  • RE: CPU utilization going 100% while running a select query.

    kiran.kamuganti (9/11/2009)

    Hi All,

    An issue was raised by a user saying that select process is very slow on the database.

    I checked with with the same query and observed that, 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)

    September 11, 2009 at 8:42 pm

    #1052629

  • RE: Which is the fastest way to move a table from one DB to another ?

    SELECT *

    INTO NewDb.NewSchema.NewTable

    FROM Olddb.OldSchema.OldTable

    Then, script the indexes and constraints and run those.

    I'm not near an SQL Server right now and I forget if Identity columns will remain as Identity columns...

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

    September 11, 2009 at 8:36 pm

    #1052627

  • RE: How do I wildcard search all columns in a database?

    Lowell (9/11/2009)

    Seth thank you for the compliment! it means a lot coming from someone like yourself, who spends a lot of time trying to help folks here.

    i guess the issue...

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

    September 11, 2009 at 8:31 pm

    #1052626

  • RE: Moore's Law

    As a performance-tuning consultant, I anxiously await the next revelation in CPU's, Memory, and the impending explosion of solid state storage devices... which will, of course be followed by 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)

    September 11, 2009 at 8:12 pm

    #1052623

  • RE: Changing Usernames

    Jamie Batiste (9/11/2009)

    I'd love to see your corrective T-SQL Steve - good article material. I want to see timings using complex SQL, use of temporary tables and for Jeff M'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)

    September 11, 2009 at 5:01 pm

    #1052615

  • RE: SQLBits

    Zowie! I've worked for some bad companies before but never had anything quite that bad happen. Usually the aberrant manager got educated or greased long before something 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)

    September 11, 2009 at 4:52 pm

    #1052611

  • RE: Very slow response times.

    Actually, I apologize... I had my trobleshooting hat on. It's actually none of my business and you folks have been making constant improvements to the site and the user...

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

    September 11, 2009 at 4:41 pm

    #1052610

  • RE: Help with BCP format error

    MountainBig (9/11/2009)

    I tried using all the variations of -r "/n" -r/n or -r"square" -r"0x0D" -r0x0D with spaces without spaces but still 0 rows copied. maybe the bulk insert might be...

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

    September 11, 2009 at 4:33 pm

    #1052608

  • RE: Delete Duplicate values

    Thank you for the feedback... Kenny actually did all the heavy lifting, though.

    Thanks, Ken.

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

    September 11, 2009 at 4:07 pm

    #1052601

  • RE: Using the Best

    rja.carnegie (9/11/2009)

    We get it, you hate non-set-based programming. But sometimes an exercise has to consist of more than one SQL statement. And while only in unusual circumstances should...

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

    September 11, 2009 at 3:34 pm

    #1052591

  • RE: Very slow response times.

    I guess I'd have to ask, "What changed?" This didn't use to happen ever.

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

    September 11, 2009 at 1:57 pm

    #1052546

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/11/2009)

    Jack Corbett (9/11/2009)

    Silverfox (9/11/2009)

    Do you know what really frustates me at times, is when someone posts after you have posted, and says, yes that is correct or says...

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

    September 11, 2009 at 1:49 pm

    #1052540

  • RE: Memory pressure when calling a C# assembly

    Jeff Moden (9/8/2009)

    I can't help on the problem you're having, Daniel, but I am curious... what does the CLR do?

    Heh... you can avoid all this memory problem stuff by avoiding...

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

    September 11, 2009 at 1:34 pm

    #1052533

Viewing 15 posts - 41,986 through 42,000 (of 59,098 total)