Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/14/2010)

    GilaMonster (12/14/2010)

    Thunderstorms here, but no snow storms. (I'd worry if there were)

    Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.

    It almost...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 14, 2010 at 9:46 am

    #1262317

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/14/2010)

    LutzM (12/14/2010)

    Alvin Ramard (12/14/2010)

    I'd prefer a picture of the horse stepping on the iPad. 😀

    But I hope you'll allow Jeff to let the iPad go before....

    Sure. ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 14, 2010 at 9:38 am

    #1262312

  • RE: Round to next 1000 or 100 without Ceiling function

    Another option not using any of the ROUND/FLOOR/CEILING functions:

    PRINT (CAST(12307.96 AS INT)/1000 + 1)*1000

    Does it make sense to use it? I don't think so.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 14, 2010 at 9:33 am

    #1262310

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/14/2010)

    I'd prefer a picture of the horse stepping on the iPad. 😀

    But I hope you'll allow Jeff to let the iPad go before....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 14, 2010 at 9:18 am

    #1262305

  • RE: Need some help with a large data volume optimization

    Craig Farrell (12/13/2010)

    Alright, I'll bite. Anyone know how to turn a column from a stream in an SSIS package into a non-nullable version of itself? Data Conversion seemed...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 4:34 pm

    #1261981

  • RE: Putting id's in contiguous order and batches using a tally table.

    Here's an example of the concept I mentioned in my previous post:

    CREATE TABLE #temp

    (

    id INT IDENTITY(1,1),

    val INT,

    grp AS val-id persisted

    )

    INSERT INTO #temp (val)

    SELECT 0 UNION ALL

    SELECT 2...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 4:23 pm

    #1261980

  • RE: Need some help with a large data volume optimization

    Paul White NZ (12/13/2010)

    Craig Farrell (12/13/2010)

    As I'm wrapping my head around this, your comment above concerns me. This approach is as valid in 2k5 as well, right?

    Yes :laugh:

    All things...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 10:06 am

    #1261819

  • RE: Need some help with a large data volume optimization

    Hi Paul,

    that really is a very interesting approach to deal with large volume tables. I guess the partition sturcture of some of our archive tables might change soon! (We're currently...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 9:33 am

    #1261795

  • RE: SELECT IF greater than within specified period

    Based on your sample data, what is your expected result?

    And what have you tried so far?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 7:51 am

    #1261712

  • RE: Putting id's in contiguous order and batches using a tally table.

    Steve Bergkamp (12/13/2010)

    Thank you for the reply. I forgot one crucial piece of information. This has to run on SQL Server 2000 so the Over syntax, ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 7:48 am

    #1261709

  • RE: Putting id's in contiguous order and batches using a tally table.

    I'd recommend you use a grouping concept like

    Id-ROW_NUMBER OVER(ORDER BY Id)

    So you Batches would be -1,0 and 1.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 13, 2010 at 5:56 am

    #1261639

  • RE: Remove duplicate records based on record id, annoying GROUP BY statement

    petervdkerk (12/12/2010)

    Sorry if I wasnt clear, but by this "what I'd rather not have to do is individually insert the column names that are to be selected and inserted.", I...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 12, 2010 at 9:06 am

    #1261426

  • RE: Calling function twice in same select

    If your ReallyComplicatedCode is based on columns of the same row in the same table you could add a computed (persisted) column to the table and use that in your...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 12, 2010 at 7:34 am

    #1261418

  • RE: How can I get this selection in one TSQL run ?

    Digs (12/11/2010)

    ...All I need is a guru to spend 1 sec of his time to post some TSQL, on show how too??

    ... and your homework is done... 😉

    If it's not...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 11, 2010 at 11:21 am

    #1261308

  • RE: Syntax for creating packages in SQL Server 2000

    What have you tried so far as a source?

    I'd expect google will return numerous related articles being a lot more specific than a forum post can be...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    December 11, 2010 at 10:33 am

    #1261298

Viewing 15 posts - 2,431 through 2,445 (of 5,502 total)