Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 5,502 total)

  • RE: Index with Included columns with 80 compatibility mode

    Did you try to setup a test scenario where the index would be used?


    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 30, 2010 at 9:21 am

    #1267750

  • RE: Are the posted questions getting worse?

    Edit: removed as announced. (due to inappropriate content.)


    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 30, 2010 at 8:50 am

    #1267734

  • RE: Does login need be created to create a schema

    Pete23Mid (12/30/2010)

    You can as well create databases / schemas for themselves and than change ownership to their logins. You can do it in any order you want, database first, or...


    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 30, 2010 at 8:42 am

    #1267728

  • RE: Are the posted questions getting worse?

    GSquared (12/30/2010)

    I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.

    Congrats, Gus!! To climb the Olymp just before a new...


    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 30, 2010 at 8:32 am

    #1267718

  • RE: Using Integration Services without GUI?

    * Oren created NHibernate, the competitor to Entity Framework

    [SARCASM ON]

    I don't think anyone involved in the NHibernate development should be allowed to write stuff like "I hate SSIS".

    [SARCASM OFF]

    Honestly, using...


    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 30, 2010 at 7:55 am

    #1267692

  • RE: cross-tab query

    Even if there is no "bottom of the column", you could either use WITH ROLLUP or you could calculate the values within your CrossTab. In order to control that total...


    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 30, 2010 at 7:08 am

    #1267667

  • RE: How to create duplicate records in a table without using cursors

    If you don't have a tally table already (which is very useful in several cases) you could take the "master..spt_values" apporach:

    DECLARE @tbl TABLE

    (

    EntryID INT,

    ...


    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 30, 2010 at 6:43 am

    #1267653

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/30/2010)

    ...

    This isn't a POV issue, Lutz. It is, by every legal definition of the term, pure and simple copyright violation. It doesn't matter that he linked to...


    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 30, 2010 at 6:30 am

    #1267646

  • RE: Table for Object with Multiple States

    I don't think you'll get the help you're looking for in a forum.

    All we can do is point you in a direction or help you with a specific question.

    But to...


    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 30, 2010 at 5:24 am

    #1267621

  • RE: Split Table while keeping only unique records

    danavni (12/30/2010)

    Hi Lutz,

    thanks for the message. these tables where built by me about 6-7 years ago when i didn't know too much SQL. when the tables where small and held...


    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 30, 2010 at 4:22 am

    #1267610

  • RE: Table for Object with Multiple States

    If all this info is in the same table it's a lot more easier to create the query...

    So i need to come up with a solution that do all this,...


    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 30, 2010 at 4:14 am

    #1267608

  • RE: How to Get Full Name using Query

    rizkhan92 (12/30/2010)

    Brother this procedure is not written by me it has written by someone else.

    and i am a new internee over this organization..

    thats y i ask you to solve this...


    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 30, 2010 at 3:57 am

    #1267602

  • RE: Split Table while keeping only unique records

    Regarding the table size itself:

    I noticed you're using FLOAT quite often (e.g. for [X], [Y], and [Speed]). Float will use 8 byte.

    You could change the Speed column to smallint (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 30, 2010 at 3:43 am

    #1267598

  • RE: How to Get Full Name using Query

    After a first glance at the 250 lines of undocumented code I don't think you'll need a those nested c.u.r.s.o.r.s *cough* at all.

    I'm confident the issue can be resolved with...


    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 30, 2010 at 3:26 am

    #1267594

  • RE: Problem with top record

    Ok, based on harinerella great setup for the sample data here's my approach (based on ROW_NUMBER to get numbered list without gaps and a self join to that list):

    WITH cte...


    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 30, 2010 at 3:02 am

    #1267588

Viewing 15 posts - 2,281 through 2,295 (of 5,502 total)