Forum Replies Created

Viewing 15 posts - 24,211 through 24,225 (of 59,102 total)

  • RE: outragous query duration during load

    aviadavi (3/6/2014)

    Hi,

    I'm performing a load test on my SQL server.

    I start a load of one main stored procedure in our SQL and after 7 minutes (when it gets to ~2500...

    --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 10, 2014 at 8:02 am

    #1695532

  • RE: Sudden PLE Drop Possible Without Memory Pressure?

    timothy.lazarus (3/9/2014)

    Okay, after reading through everything I could get my hands on regarding SQL memory, I think I've identified the culprit. Per VMware's recommendation, I had enabled large page allocation....

    --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 10, 2014 at 7:54 am

    #1695526

  • RE: How to influence others?

    The only way to influence those that can be influenced is to be right and to be able to prove it without question. As the old saying goes, 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)

    March 9, 2014 at 11:26 am

    #1695382

  • RE: Perform an update but skip lock

    laser_steve (3/7/2014)

    Thanks all for the replies. I know the system performing the locks is bad, why they couldn't have gone for optimistic locking I'll never know. But I cannot control...

    --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 8, 2014 at 11:52 pm

    #1695350

  • RE: avoid self join

    mxy (3/8/2014)

    max would be two column per employee. its a report they want to view payments and dates of each employee in that format.

    I know but, how may employees per...

    --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 8, 2014 at 11:31 pm

    #1695349

  • RE: avoid self join

    mxy (3/8/2014)

    i would like to do display results as below. I can achieve results by self joining back, is there any other way we can achieve

    o/p should be

    batchidempsalpaiddateempsal1paiddate1

    2 ...

    --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 8, 2014 at 2:50 pm

    #1695330

  • RE: recursive Stored procedure or function

    Eskandari (3/5/2014)

    is there any way to have a stored procedure or function like below c# code:

    Comment :"i want to convert this c# code to sql server t-sql "

    public static IEnumerable<String>...

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

    #1695283

  • RE: Split a pipe delimited string into two columns

    dwain.c (3/6/2014)

    There's no reason to call DelimitedSplit8K twice, even if it is super-efficient (bless its heart):

    WITH SampleData (s) AS

    (

    SELECT 'XYZ00001|Test_b|XYZ00002|Test_a|XYZ00003|Test_c'

    )

    SELECT s

    ,Col1=MAX(CASE WHEN...

    --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 7, 2014 at 5:07 pm

    #1695280

  • RE: Copy from Excel file into SQL table using BCP

    tracmonali (3/7/2014)

    Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not...

    --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 7, 2014 at 5:03 pm

    #1695279

  • RE: SQL Server Work Ethic

    I think what Travis is referring to is something that I've recently encountered and it does have quite a bit to do with "work ethic". While it's certainly not...

    --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 7, 2014 at 4:55 pm

    #1695278

  • RE: How to add up the monthly total?

    MyDoggieJessie (3/7/2014)

    To add to SQLCJ's post, you will need to include the ORDER BY date_value at the end to get the OP's expected result - and some ugly string manipulation...

    --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 7, 2014 at 4:37 pm

    #1695275

  • RE: Multiple backup at the same time

    Jack Corbett (3/7/2014)

    I would question why you'd want to run them in parallel if you are writing them all to the same drive, especially if all the databases...

    --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 7, 2014 at 4:13 pm

    #1695274

  • RE: Update Query

    vijaykumar587 (3/7/2014)

    I am sorry for that. Actually there is common column is there in two tables. Please check below

    Table1:

    PID ID1 ID2 ID3 ID4 ID5 ID6

    1 NULL NULL NULL NULL NULL...

    --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 7, 2014 at 4:09 pm

    #1695273

  • RE: Capturing the Reason For Change for Type 2 changes

    Lempster (3/3/2014)

    Jeff Moden (2/28/2014)

    Put an index on the "Current-Flag" and watch your GUI's timeout when they try to do an INSERT because of the massive extent splits that will occur....

    --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, 2014 at 3:17 pm

    #1694512

  • RE: How to shrink log in 2008 r2? URGENT!!!!!!

    GilaMonster (3/5/2014)

    Jeff Moden (3/4/2014)

    Almost forgot. The log file won't shrink past the last VLF currently in use. It is sometimes necessary to first take a backup of 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)

    March 5, 2014 at 3:06 pm

    #1694507

Viewing 15 posts - 24,211 through 24,225 (of 59,102 total)