Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 5,502 total)

  • RE: Data Cache Problem

    SC48035 (5/31/2011)

    @LutzM & @ninja: Thanks for the suggestion, I have noticed a couple of stored procedures have benefited by using CTEs and removing UDF calls. I am trying to rewrite...


    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]

    May 31, 2011 at 12:53 pm

    #1332222

  • RE: Can this be converted to a set based query?

    GSquared (5/31/2011)

    ...GSquared, OEC, FEBC, HDA, RSVP, OODA, MAP, NMVP, ARCSW, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ETC

    Gus, you didn't take 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]

    May 31, 2011 at 12:49 pm

    #1332216

  • RE: Data Cache Problem

    I'm not sure if the query itself got "transported" properly since it looks like there is no join between MainDistricts/offices on one side and the Customers "join group" on 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]

    May 31, 2011 at 12:31 pm

    #1332200

  • RE: Can this be converted to a set based query?

    At a first glance I thought it's a running total problem, too. But I'm not sure anymore. It might be possible to do it all set based. But I'd 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]

    May 31, 2011 at 11:00 am

    #1332126

  • RE: SQL Profiler Query

    4.5mill rows is still not "large" for some of us.... 😉

    If you could provide the actual execution plan for the two heaviest queries we migt be able to give 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]

    May 30, 2011 at 1:46 pm

    #1331727

  • RE: Problem With Recursive CTE

    It actually doesn't make sense to me: why don't you just store the customer specific product name together with your internal product name in a separate table? Then you wouldn'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]

    May 30, 2011 at 12:46 pm

    #1331717

  • RE: SQL Profiler Query

    Is this just a single query taking 20 minutes?

    500k rows is not really that much...

    If it's just a single query, can you post the actual execution plan?


    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]

    May 30, 2011 at 12:31 pm

    #1331712

  • RE: Ignore Columns at destination

    If the destination table has a NOT NULL constraint on the remaining two columns you need to insert the related values.

    Please talk to the DBA in charge what values are...


    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]

    May 30, 2011 at 12:15 pm

    #1331710

  • RE: Rows to Columns

    Additionally to the PIVOT recommended above you could use the good old CrossTab approach.

    For an example please have a look at the related article referenced in my signature.


    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]

    May 30, 2011 at 12:08 pm

    #1331707

  • RE: An Application Error:

    This link might help you getting started.


    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]

    May 30, 2011 at 10:19 am

    #1331683

  • RE: Data Cache Problem

    Syed Jahanzaib Bin hassan (5/30/2011)

    @"Mr. Alphabet Soup":

    It starts to get annoying to see replies with the "answer" being a lot shorter than the alphabet soup under your name. Sometimes you're...


    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]

    May 30, 2011 at 10:04 am

    #1331677

  • RE: sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

    The link I provided was to demonstrate how to narrow down the issue.

    Did you try finding other web references for the other error codes you posted?


    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]

    May 30, 2011 at 9:40 am

    #1331667

  • RE: Loop Thru a Table

    subrata.bauri-1051938 (5/30/2011)

    kindly reply

    Please note that we are all volunteers and we're not spending each and every minute waiting to reply on a post. Asking for an answer just 15 minutes...


    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]

    May 30, 2011 at 7:44 am

    #1331628

  • RE: Can this be converted to a set based query?

    It most certainly can be converted into a set based query (maybe using the divide'n'conquer approach).

    We'd need table def and sample data for all tables involved in a ready 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]

    May 30, 2011 at 7:38 am

    #1331624

  • RE: Loop Thru a Table

    Please provide table def and sample data in a ready to use format as described in the first link in my signature together with your expected result.

    I'm confident there's a...


    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]

    May 30, 2011 at 2:11 am

    #1331533

Viewing 15 posts - 1,456 through 1,470 (of 5,502 total)