Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 5,502 total)

  • RE: unique problem with t-sql

    No, it's not your fault. Be assured, there are others following this thread just waiting for some sample data and expected results. Ready to use SQL code will explain much...


    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]

    September 5, 2011 at 1:21 pm

    #1377142

  • RE: Performance issue by Checkpoint ?

    Wow. 45min and 120min... Sounds like an enormous complex query. Or one that calls desperately for a deep analysis. Can you post some rough figures about this monster?


    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]

    September 5, 2011 at 1:07 pm

    #1377141

  • RE: Query for datatype difference

    You could get the relevant rows from sys.columns of db_B and db_A and compare those (e.g. using a full outer join on sys.columns.name).


    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]

    September 5, 2011 at 11:08 am

    #1377112

  • RE: Security for the Dev Team

    Adding to what Roy already pointed out:

    What exactly is the reason for allowing a dev team to access the prod system? What permissions would you like to remove? And why...


    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]

    September 5, 2011 at 10:51 am

    #1377105

  • RE: is there any OPEN Source services like SSAS

    Did you try to google it?

    Would you please be a little more specific what you're looking for?

    SSAS is included in SQL Server Standard, Enterprise and Developer edition at no additional...


    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]

    September 5, 2011 at 7:27 am

    #1377033

  • RE: Query optimization

    forsqlserver (9/5/2011)

    loop

    What exactly are you trying to tell us?

    I've noticed a few of your "loop" posts recently but I can't figure out the intention behind it...


    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]

    September 5, 2011 at 7:16 am

    #1377030

  • RE: SqlServer Stored Proceedure

    You could try to use FREETEXT search and see if it provides what you're looking for.

    http://msdn.microsoft.com/en-us/library/ms187787%28v=SQL.90%29.aspx


    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]

    September 4, 2011 at 8:16 am

    #1376868

  • RE: SqlServer Stored Proceedure

    duplicate post. no replies please.

    original post: http://www.sqlservercentral.com/Forums/FindPost1169697.aspx


    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]

    September 4, 2011 at 8:14 am

    #1376867

  • RE: Client Notification methodology

    You could look into Service Broker and External Activation.

    The external application would need to take care of processing the UDP messages (including a possible return message to the calling broker...


    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]

    September 2, 2011 at 3:12 pm

    #1376703

  • RE: ERP systems and vendors

    Wow!

    I hope you can continue using this methodology (from unobfuscated access to the trial system to the concept how to involve the end users). It's the right way to go,...


    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]

    September 2, 2011 at 1:25 pm

    #1376660

  • RE: Deleting records from table

    Depending on the percentage of rows to delete it might be more effcient to copy the remaining rows into a new table and rename it. It depends...

    As an alternative you...


    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]

    September 2, 2011 at 12:21 pm

    #1376622

  • RE: ERP systems and vendors

    The most important part is to know what you expect from an ERP in terms of functionality.

    Then try to find the vendor that best fit your requirements with the least...


    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]

    September 2, 2011 at 11:32 am

    #1376594

  • RE: 50 Gb msdb ate disk

    juan08 (9/2/2011)

    Thank you for helping ALZDBA.

    The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t...


    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]

    September 2, 2011 at 10:16 am

    #1376543

  • RE: Select where statement issue

    Salil-386686 (9/2/2011)

    Hi

    I think this would be a better bet

    select * from Form where FromID not in(3,4)

    Thanks

    Salil

    I recommend to run both versions and compare the exection plans... 😉

    (Hint: FromID not in(3,4)...


    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]

    September 2, 2011 at 9:48 am

    #1376526

  • RE: 50 Gb msdb ate disk

    juan08 (9/2/2011)

    Thank you for helping ALZDBA.

    The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t...


    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]

    September 2, 2011 at 9:44 am

    #1376521

Viewing 15 posts - 1,021 through 1,035 (of 5,502 total)