Forum Replies Created

Viewing 15 posts - 27,916 through 27,930 (of 59,101 total)

  • RE: Dynamic PIVOT CLR

    Sigh! SPAM reported.

    --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 8, 2012 at 10:20 pm

    #1566860

  • RE: Memory usage

    mah_j (12/8/2012)

    HI

    In our server when we have time out in select & insert we have lack of memory.

    the total memory is 24G,and free mem is 800M.

    max server memory is 20480...

    --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 8, 2012 at 10:16 pm

    #1566859

  • RE: Update Gaps

    Sam S Kolli (12/6/2012)

    Let me say before hand that Jeff Moden's solution is better than this for the specific task you asked for; (on my laptop, my solution is 85%...

    --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 8, 2012 at 9:13 pm

    #1566858

  • RE: First Post with a very basic query request

    blackhawkpowers (12/8/2012)

    there's the current query and here's some of the data...

    WorkOrderIDWorkOrderIdentifierDateOpenedDateClosedPMProjectIDNoteIdentifierArchivedIsDeleted

    46512_0026872012-08-02 02:14:59.0002012-08-11 01:53:21.000NULL823600

    46612_0026882012-08-02 06:00:41.0002012-09-11 17:51:55.00014823900

    46712_0026892012-08-02 06:00:43.0002012-09-11 17:50:47.00014824200

    46812_0026902012-08-02 06:00:44.0002012-09-11 17:49:36.00014824500

    46912_0026912012-08-02 06:00:45.0002012-09-11 17:48:08.00014824800

    Howdy!

    Welcome aboard! If you'll take the time to post...

    --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 8, 2012 at 6:15 pm

    #1566854

  • RE: Hierarchy: Check Constraint to Prevent Child->Parent and Parent->Child

    trapnell (12/8/2012)

    How do I write a check constraint which precludes this situtation in a hierarchy table:

    Child |Parent

    -------------------

    Tom |Joe

    Joe ...

    --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 8, 2012 at 6:03 pm

    #1566853

  • RE: What Counts for a DBA: Being Replaceable

    What an incredible article. I wish more people had that attitude. I've often told people that if you're indespensable in your current position, you can't get a promotion,...

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

    #1566850

  • RE: Loading change data from AS400 (or other source systems)

    Hi Shannon,

    I didn't have the time to build you a complete system but this is an example of what I'm talking about. Details, some programmer's notes, and a run-able...

    --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 8, 2012 at 3:37 pm

    #1566849

  • RE: Loading change data from AS400 (or other source systems)

    shannonjk (12/7/2012)

    Jeff Moden (12/7/2012)

    I guess my question would be, why do you need to use SSIS for this task? Why not just grab the data using OPENQUERY from 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 8, 2012 at 12:53 pm

    #1566839

  • RE: Missing Number Find out

    vs.satheesh (12/7/2012)

    HI Still i am not getting answer.One small changes I use only one table,that table i store a values like a

    registerno

    101

    102

    103

    104

    105

    106

    107

    109

    110

    120

    121

    122

    123

    124

    125

    127

    129

    130

    I want following result like following manner

    101-107,109-110,120-125,127,129-130

    Please help...

    --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 8, 2012 at 11:56 am

    #1566838

  • RE: Trend Rolling Table

    Erin-489205 (12/6/2012)

    Development has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over 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 7, 2012 at 7:37 pm

    #1566818

  • RE: Substring Records

    kiran.rajenimbalkar (12/7/2012)

    Hi Expert,

    I want to show only AFG,USA,INDfrom my below table..

    CREATE TABLE test(

    [ENAME] [varchar](30) NULL,

    )

    insert into test values ('Afghanistan [AFG]')

    insert into test values('Brazil [BRA]')

    insert into test values('United States [USA]')

    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 7, 2012 at 7:26 pm

    #1566817

  • RE: Missing Number Find out

    sql_lock (12/7/2012)

    Try this

    ;WITH Missing (missnum, maxid)

    AS

    (

    SELECT

    1 AS missnum, (select max(RegisterNo )

    FROM

    dbo.studentMaster)

    UNION ALL

    SELECT

    missnum + 1, maxid

    FROM

    Missing

    WHERE

    missnum <...

    --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 7, 2012 at 7:19 pm

    #1566816

  • RE: Dropping #temp tables at the end of stored procedure

    sestell1 (12/7/2012)

    I had an 'analyst' once who would create dozens of temp tables with huge amounts of data in them, never drop them, and leave his sessions open for days....

    --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 7, 2012 at 7:12 pm

    #1566815

  • RE: Loading change data from AS400 (or other source systems)

    I guess my question would be, why do you need to use SSIS for this task? Why not just grab the data using OPENQUERY from a linked server 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)

    December 7, 2012 at 7:05 pm

    #1566813

  • RE: Interview Questions

    komal145 (12/7/2012)

    I know , it's kind of DBA questions and they are excepting the Developer to answer it and I am a Newbie to SQL server ,and never faced such...

    --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 7, 2012 at 5:08 pm

    #1566810

Viewing 15 posts - 27,916 through 27,930 (of 59,101 total)