Forum Replies Created

Viewing 15 posts - 19,471 through 19,485 (of 59,072 total)

  • RE: SSIS package jobs in SQL 2012 failing with deadlocks

    Thanks for the links, folks.

    --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 7, 2015 at 10:33 am

    #1832064

  • RE: Aging Software

    My problem with "new and improved" software is that the software vendor frequently decides to no longer support features that are actually incredibly useful. To wit, it may 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)

    October 7, 2015 at 8:13 am

    #1832011

  • RE: SSIS package jobs in SQL 2012 failing with deadlocks

    AlexSQLForums (10/7/2015)

    Prakash.Bhojegowda (10/6/2015)

    SSIS package jobs in SQL 2012 failing with deadlocks. Execution Report of SSIS package has “ Created Execution” status

    Issue: SQL Agent jobs running an SSIS packages failed with...

    --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 7, 2015 at 8:00 am

    #1832005

  • RE: Listing user created objects

    tnpich (10/7/2015)

    I'm trying to list everything (tables, view, procedures, functions, etc.) that was created by users in a database.

    The query which seems to eliminate the most SQL system type...

    --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 7, 2015 at 7:58 am

    #1832003

  • RE: Convert SQL table to XML

    devesh.hassani (10/7/2015)

    Hi Jeff,

    I got a sample file from configuration team and them want the data output in the given format to upload it. The sample file that I receive was...

    --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 7, 2015 at 7:18 am

    #1831982

  • RE: Convert SQL table to XML

    devesh.hassani (10/5/2015)

    Thanks! for the suggestion Jeff.

    Can you please explain how can we do the export from SQL as i am not sure on the process.

    Thanks,

    DH

    I guess the first question 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)

    October 6, 2015 at 7:42 pm

    #1831893

  • RE: Convert SQL table to XML

    devesh.hassani (10/5/2015)

    Hi,

    I want to convert table into following xml format. Sample two records is given below. Any help would be appreciated.

    <Row>

    <Cell ss:StyleID="s22">

    <Data ss:Type="String">XXXXXXXXXXXXX</Data>

    </Cell>

    <Cell ss:StyleID="s22">

    <Data ss:Type="String">64856</Data>

    </Cell>

    <Cell ss:StyleID="s22">

    <Data ss:Type="String">Test001</Data>

    </Cell>

    </ROW>

    <Row>

    <Cell ss:StyleID="s22">

    <Data ss:Type="String">XXXXXXXXXXXXX</Data>

    </Cell>

    <Cell...

    --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 5, 2015 at 10:14 am

    #1831456

  • RE: Why so some suggest converting to SIMPLE prior to shrinking LOG file

    GilaMonster (10/2/2015)

    chuck.forbes (10/2/2015)

    You're right, the file isn't 99% unused, it's 99% used. I interpreted that backwards. I can see the need for the checkpoint now.

    Checkpoint won't do anything,...

    --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 5, 2015 at 10:13 am

    #1831454

  • RE: Write Cleaner T-SQL Using Version Control

    [font="Arial Black"]From the Article:[/font]

    So if we take out the code that has been commented out by not being reachable we end up with:

    create procedure usp_DoSomething (@PARAMETER int)

    as

    ...

    --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 5, 2015 at 5:50 am

    #1831338

  • RE: convert rows to columns in query

    elham_azizi_62 (10/5/2015)

    hello J Livingston.

    My output have more than 1 column and column's names are:

    PersonelNumber,FirstName,LastName,BaseSalary,BaseSalaryAmount,ExtraSalary,ExtraSalaryAmount,SpecialSalary,SpecialSalaryAmount.

    It's time to stop guessing. Please see the article at the first link in my signature...

    --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 5, 2015 at 5:29 am

    #1831336

  • RE: Partitioning Table Strategie

    ps_vbdev (10/5/2015)

    Oh OK

    somehow ive picked this up wrong. I was under the impression that partitioning the data would give benefit in the form of sql server not having to 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)

    October 5, 2015 at 5:25 am

    #1831334

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    Eric M Russell (10/3/2015)

    898 million page reads? Each page is 8'000 bytes... :w00t:

    The final 42 million reads is pretty bad, as well, even for a batch run. That's like...

    --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 5, 2015 at 5:18 am

    #1831333

  • RE: What's a Code Smell?

    I think that what some people consider to be a "code smell" is sometimes actually an indication that the person that wrote the code has a very good handle on...

    --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 4, 2015 at 7:00 am

    #1831262

  • RE: First date of the Month (to date on Range basis)

    Understood. But, with the exception of the abbreviation for "microseconds", which would really have been cool as the more standard "us" instead of "mcs", I just don't have 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)

    October 2, 2015 at 6:51 am

    #1831024

  • RE: Return result of dynamic query from function

    vinod.andani-874416 (10/1/2015)

    Its because, semicolon missing at the end of return statement.

    Use the simplified one below :

    CREATE FUNCTION dbo.ExecuteStringAsQuery (@empID as nvarchar(500))

    RETURNS Varchar(8000)

    AS

    BEGIN

    /* Build Transact-SQL String with parameter value */

    return(select JoinDateQuery...

    --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 2, 2015 at 5:49 am

    #1831008

Viewing 15 posts - 19,471 through 19,485 (of 59,072 total)