Forum Replies Created

Viewing 15 posts - 36,871 through 36,885 (of 59,098 total)

  • RE: XML "CSV" Splitter

    Peter Brinkhaus (9/13/2010)

    I am not an XML Ninja either, but you can try a inline table valued function

    CREATE FUNCTION dbo.Split8KX_Inline(@Parameter VARCHAR(MAX), @Delimiter VARCHAR(1))

    RETURNS TABLE

    WITH SCHEMABINDING

    AS

    RETURN

    ...

    --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 13, 2010 at 4:28 am

    #1219937

  • RE: Top 10 SQL Server Integration Services Best Practices

    Trevor R Udden (9/13/2010)

    Odanwada -

    Did I miss a major citiation at the end of your article? You might want to try not blantly plagirizing others work. 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 13, 2010 at 4:20 am

    #1219936

  • RE: XML "CSV" Splitter

    p.s. Sorry that I don't document my code or anything and that I don't follow any formatting rules... I'm new at this... :-P:-D:hehe:

    --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 12, 2010 at 11:08 pm

    #1219849

  • RE: XML "CSV" Splitter

    For your convenience, here's a copy of the Tally table I used. You can use it in Temp DB without it interfering with your own...

    --===== Do this in 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)

    September 12, 2010 at 11:06 pm

    #1219848

  • RE: XML "CSV" Splitter

    There are 3 places that control what the table looks like. Of course, two of those are SELECT TOP (X) and the comments next to each of those explain...

    --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 12, 2010 at 11:01 pm

    #1219846

  • RE: XML "CSV" Splitter

    WayneS (9/12/2010)

    If you will post your sample data creation, I'll give it a test...

    Coming right up...

    --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 12, 2010 at 10:52 pm

    #1219844

  • RE: Searching for Plans

    The "best plan" is dictated only by four things and only two of those really matter where performance is concerned...

    1. Hardware - Nill effect. Double the speed 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)

    September 12, 2010 at 10:49 pm

    #1219843

  • RE: Searching for Plans

    CirquedeSQLeil (9/11/2010)

    Why not have something like that with the optimizer for query plans.

    I believe because it's mostly not worth it. How many query plans do you want the optimizer...

    --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 12, 2010 at 10:40 pm

    #1219842

  • RE: Top 10 SQL Server Integration Services Best Practices

    I strongly suspect that 4.5 million sales transactions per second requires a fair bit of pretty expensive hardware and a whole lot of parallelism. I'm pretty sure that most...

    --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 12, 2010 at 10:34 pm

    #1219841

  • RE: Creating large semi-random data sets without cursors

    It's also odd that you posted this in "Anything that is NOT about SQL" because this problem is all about SQL. 😉

    --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 12, 2010 at 10:22 pm

    #1219835

  • RE: Unexpected Columns being set to NULL with record updates

    d_s_man (9/9/2010)

    I have a strange problem that doesnt make any sense.

    I have a partitioned table with 175188842 rows. Any updates to any of the rows is setting certain columns 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)

    September 12, 2010 at 10:19 pm

    #1219833

  • RE: Calling a UDF

    vani_r14 (9/11/2010)

    We have a requirement of finding data that has been entered incorrectly into the database by staff members and sending an email to them every fortnight with an attachment...

    --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 12, 2010 at 10:14 pm

    #1219831

  • RE: Multi-parent heirarchy query

    james.mcallester (9/12/2010)

    Thanks to all who replied to this. Only had a chance to come back now to provide a final, closing post.

    The problem was solved by the follow CTE:

    DECLARE @ManagerID...

    --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 12, 2010 at 9:57 pm

    #1219827

  • RE: Storing Negative Numbers

    It is an old thread but same goes here... OMG... Debit/Credit columns meaning one thing in Accounts Payable and meaning just the opposite in Accounts Receivable. And you had...

    --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 12, 2010 at 9:31 pm

    #1219823

  • RE: Blocking on tempdb system tables

    sporoy (9/12/2010)

    Hi, we are having blocking issues with tempdb database, blocking transaction is open for 30 minutes and has create table #Table statements in it, because of this...

    --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 12, 2010 at 9:13 pm

    #1219820

Viewing 15 posts - 36,871 through 36,885 (of 59,098 total)