Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (4/23/2011)

    Jack Corbett (4/23/2011)

    So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.

    http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx

    Want to swap? I'm having some amusement with someone...


    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]

    April 23, 2011 at 1:15 pm

    #1315167

  • RE: Is SSIS actually useful?

    I think SSIS is "just" an alternative to some of the tools Jeff mentioned. Nothing more, but nothing less either.

    There are two tasks I prefer using SSIS:

    a) export 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]

    April 23, 2011 at 12:29 pm

    #1315154

  • RE: need help t-sql want to select all the records when some condition fails

    First of all it seems like it's a "catch-all-query"[/url] type.

    I'm confident this query will (almost) always end up using a table scan...

    Furthermore, what do consider being the difference between parameter...


    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]

    April 23, 2011 at 4:37 am

    #1315117

  • RE: Running Total's CTE Challenge

    Would the following snippet do the trick?

    -- Drop information into a temp table 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]

    April 23, 2011 at 4:05 am

    #1315115

  • RE: How to Add Column Header

    @Phil: the way I read it is that the OP needs Excel to add the column names manually and (guessing starts here) will import it into SQL Server based on...


    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]

    April 23, 2011 at 3:52 am

    #1315113

  • RE: FTS - Select Distinct Column With Highest Rank

    How about using

    ROW_NUMBER() OVER(PARTITION BY homepage ORDER BY highest rank desc) as pos

    and select the top 10 rows with pos=1 ORDER BY highest rank desc?


    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]

    April 22, 2011 at 4:40 pm

    #1315059

  • RE: How to Add Column Header

    Would you please be a little more specific what you're trying to do?

    Do you have to import the data into SQL Server? Does the target table already exist?

    What method do...


    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]

    April 22, 2011 at 4:33 pm

    #1315058

  • RE: full table scan on partitioned table

    As I mentioned earlier it looks like you try to partition by date.

    So, let me ask again: why do you have a CHAR(20) column to store an 8 charachter date...


    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]

    April 22, 2011 at 2:00 am

    #1314801

  • RE: full table scan on partitioned table

    The description is kind of vague...

    Is the column used to partition the table identical to the column used in your WHERE clause?

    Based on what I see I'd guess the partitions...


    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]

    April 21, 2011 at 9:49 am

    #1314590

  • RE: Query to join the tables

    To answer your question in a PM that you've...

    heard that the usage of the column number is the perfect choice instead of using alias name or column name in...


    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]

    April 21, 2011 at 2:16 am

    #1314359

  • RE: Query to join the tables

    Regarding the solution you added to your original query:

    select ISNULL(a.eno,b.eno) as eno,a.no,b.no

    from ep1 a full outer join ep2 b

    on a.eno=b.eno

    should return the expected output.

    Another option would be a table holding...


    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]

    April 21, 2011 at 1:26 am

    #1314341

  • RE: Query to join the tables

    look into FULL OUTER JOIN.


    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]

    April 21, 2011 at 12:33 am

    #1314330

  • RE: Are the posted questions getting worse?

    GilaMonster (4/20/2011)

    LutzM (4/20/2011)

    Is there any other method than using the mouse pointer? There are so many words on the screen. How else to keep track where the next word is...


    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]

    April 20, 2011 at 3:33 pm

    #1314244

  • RE: can't use column in aggregate or group by - but need it to calc qty

    Glad it finally worked out for you. Thank you for the feedback!


    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]

    April 20, 2011 at 3:26 pm

    #1314242

  • RE: can't use column in aggregate or group by - but need it to calc qty

    May I ask for some sample data and expected result?

    It's still not clear what you're looking for.


    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]

    April 20, 2011 at 2:02 pm

    #1314202

Viewing 15 posts - 1,651 through 1,665 (of 5,502 total)