Forum Replies Created

Viewing 15 posts - 2,506 through 2,520 (of 5,502 total)

  • RE: Sql server 2008 R2

    What exactly is your question?

    You might want to translate it into English...


    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]

    November 28, 2010 at 1:55 am

    #1256006

  • RE: Stored Procedures for multiple like condition search

    The easiest way would be using a normalized table structure: Teams(TeamID,TeamName),Avtivities(ActivityID,ActivityName), and a table to join both: TeamActivityDays(TeamID,ActivityID,Day) (There are most probably people out there having the opinion to need...


    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]

    November 28, 2010 at 1:52 am

    #1256005

  • RE: open cursor takes long time

    What do want to do with the rows in your c.u.r.s.o.r.?

    Most likely there is a solution where you don't need that kind of a loop at all.

    An index on "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]

    November 28, 2010 at 1:06 am

    #1256001

  • RE: script included index

    If you refer to SSMS:

    RightClick on the DB in ObjectExplorer -> Tasks -> Generate Script

    In the Table section you can define to include index def.


    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]

    November 27, 2010 at 11:57 am

    #1255981

  • RE: Close,Deallocate cursor with rollback

    Why do you use a c.u.r.s.o.r. in the first place?

    Wouldn't the following statement do the same without touching the table once for every row?

    UPDATE table2

    SET Column1 =t1.Column1,Column2 = t2.column3...


    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]

    November 27, 2010 at 4:03 am

    #1255954

  • RE: Unexpected performance improving.

    Ok, I stop ranting about poorly designed MRP concepts... Just one last thing: An MRP system (among many other things) should not care about the annual number of stock transactions....


    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]

    November 27, 2010 at 3:35 am

    #1255953

  • RE: Custom excel import advice needed

    I'm definitely not an MVP, but the most efficient solution from my point of view is to get the people involved who provide the report, ask where they get the...


    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]

    November 27, 2010 at 2:55 am

    #1255948

  • RE: Unexpected performance improving.

    I think the major issue is the concept in general, not the performance varying between different systems.

    8 hrs for an MRP run??? :crying::pinch: Sounds like a SubmittAndPray solution...

    The main reason...


    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]

    November 27, 2010 at 2:47 am

    #1255947

  • RE: How to avoid Cursor in SQL Function

    You don't really need a c.u.r.s.o.r nor a function.

    What you most probably can do: use FOR XML PATH('').

    We'd be able to show you how it works but we don't have...


    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]

    November 27, 2010 at 2:24 am

    #1255945

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/26/2010)

    BWAA-HAA!!! Nothing like ratting me out to the Boss! 😛 Now I have to wait for Steve's email to tell me not to hassle the poor...


    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]

    November 27, 2010 at 1:46 am

    #1255941

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/26/2010)

    BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something...


    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]

    November 26, 2010 at 2:12 pm

    #1255904

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/26/2010)

    Celko is Celko. He has written a lot, and very well, on SQL and standards. However he's an anachronism, a throwback to the past when...


    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]

    November 26, 2010 at 2:01 pm

    #1255899

  • RE: Are the posted questions getting worse?

    ChrisM@home (11/26/2010)

    CirquedeSQLeil (11/26/2010)

    da-zero (11/26/2010)

    Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build...


    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]

    November 26, 2010 at 12:53 pm

    #1255881

  • RE: How do I run a batch file stored on one server from another?

    bajanpoet (11/25/2010)

    Sounds interesting... but can I use that to rename with a timestamp? How would I do that?

    That would definitely ease my troubles....

    I'm sure this link will help...


    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]

    November 25, 2010 at 4:43 pm

    #1255662

  • RE: How do I run a batch file stored on one server from another?

    Why don't you simply use the RenameFile option of the FileSystem task?

    I don't see any reason to call a .bat file to do 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]

    November 25, 2010 at 4:23 pm

    #1255657

Viewing 15 posts - 2,506 through 2,520 (of 5,502 total)