Forum Replies Created

Viewing 15 posts - 886 through 900 (of 5,502 total)

  • RE: OpenQuery Performance help needed urgently

    LutzM (10/23/2011)

    Create a view on the Oracle side and query the data based on the view.

    To be a little more specific (and to expand on what Grant mentioned): the view...


    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]

    October 23, 2011 at 7:21 am

    #1398447

  • RE: Vendor suggesting their issue is a limitation of sql server

    Grant Fritchey (10/23/2011)

    ...

    I just hope the vendor isn't one near & dear to my heart.

    Yeah, there are lots of reasons to use a third party backup method. For example, we...


    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]

    October 23, 2011 at 6:08 am

    #1398442

  • RE: OpenQuery Performance help needed urgently

    Create a view on the Oracle side and query the data based on the view.


    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]

    October 23, 2011 at 2:46 am

    #1398426

  • RE: extracting data from oracle source with ssis

    Looks like an oracle syntax error ("ORA-00936: missing expression").

    That would be the point to start.

    (Un)fortunately, I have no idea about oracle.


    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]

    October 23, 2011 at 2:44 am

    #1398425

  • RE: data extraction from oracle

    duplicate post. no replies please.

    Original post: http://www.sqlservercentral.com/Forums/Topic1194914-363-1.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]

    October 23, 2011 at 2:43 am

    #1398424

  • RE: Getting values from multiple rows into single row

    I guess it's more an issue of getting a comma delimited list instead of pivoted data.

    If that's the case, the FOR XML PATH approach as demonstrated here might be more...


    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]

    October 23, 2011 at 2:40 am

    #1398423

  • RE: Vendor suggesting their issue is a limitation of sql server

    kstjacques (10/21/2011)

    Thank you for all your responses!

    So the good news is the vendor is saying they will look into fixing the issue.

    My favorite part of the latest response...


    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]

    October 22, 2011 at 10:34 am

    #1398342

  • RE: Cast / Temp field conversion from nvarchar to int failing - any ideas ?

    What exactly are you trying to do?

    If there's a conversion error you might use a different data type than int for @tempian.

    Other than that it looks like there's a general...


    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]

    October 22, 2011 at 10:23 am

    #1398336

  • RE: Question about rows vs. columns

    SQL_By_Chance (10/12/2011)

    Try using CTE with ROW_NUMBER() . Delete from CTE where rowNUM > 1

    I don't think this will help here since both rows need to be merged (to combine 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]

    October 12, 2011 at 1:34 pm

    #1393681

  • RE: updating tables between 2 servers

    Elliott Whitlow (10/12/2011)

    You can't really schedule the wizard so that probably is a no-go.

    You have several options.

    ...

    You could use a linked server using a trigger.

    Lots of options, a lot depends...


    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]

    October 12, 2011 at 1:26 pm

    #1393677

  • RE: xml-like string to individual rows

    Here's a solution using XQuery to parse the (obviously) xml data. Since I don'T know the data type of the related column, I used a cte to convert it into...


    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]

    October 12, 2011 at 1:16 pm

    #1393670

  • RE: Query Optimization

    Please attach the actual execution plan (not the estimated) as sqlplan files. Jpegs won't help much here...

    Also, please post table and index definition of all tables involved and the actual...


    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]

    October 12, 2011 at 12:59 pm

    #1393660

  • RE: Execute Multiple Queries and Maintain Error Logs

    Jeff Moden (10/9/2011)

    Hmmm... Learning Service Broker would mean that I'd have to learn another SQL Server "4 letter word" 😛 but it does sound interesting. What I'd be most...


    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]

    October 9, 2011 at 2:44 pm

    #1392222

  • RE: Query plan showing index seek, Activity Monitor shows Keylocks

    It sounds like the sproc is part of a RBAR process (a loop where a few thousand acctId values are "collected" - e.g. using a c.u.r.s.o.r. *cough*).

    From my point of...


    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]

    October 9, 2011 at 10:59 am

    #1392198

  • RE: Execute Multiple Queries and Maintain Error Logs

    An alternative for such a scenario would be to use ServiceBroker. It's designed for exactly such a scenario (among others).

    There are two disadvantages of the frequent job concept: The first...


    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]

    October 9, 2011 at 10:54 am

    #1392197

Viewing 15 posts - 886 through 900 (of 5,502 total)