Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 5,502 total)

  • RE: Deadlock Transactions -- help needed

    Is there any chance for you to post the actual execution plan for the SELECT statement being part of the deadlock?

    My shot in the dark would be the SELECT 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]

    December 28, 2010 at 2:44 pm

    #1266940

  • RE: Now Do You Break The Data When Using A Group By Clause

    The current output looks straight forward in terms of a table output. You have two columns with the corresponding values.

    It seems like your question is more related to a reporting...


    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]

    December 28, 2010 at 1:15 pm

    #1266907

  • RE: Sql query Output in XML format

    lsurapaneni (12/28/2010)

    I am not getting the output in desired format.

    I tried the solution that you provided. Do I need to do nested xml? to get the nodes as below:

    ...


    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]

    December 28, 2010 at 11:26 am

    #1266845

  • RE: High memory utilization

    abhishek.8604 (12/24/2010)

    use sql profiler..tune all your queries/sp which are taking more time by applying recomendations given by the tuning advisor..if it still does not work then check in books online...


    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]

    December 24, 2010 at 4:31 am

    #1266180

  • RE: High memory utilization

    You might want to have a look at Gails article.

    At least this should get you started.

    From my point of view, performance tuning is an art all by itself. No secret...


    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]

    December 24, 2010 at 3:42 am

    #1266171

  • RE: How to load data into SQL Server in which columns are formated vertically

    I would need a sample file and the target table structure as DDL scripts so I have something to test my solution against.


    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]

    December 23, 2010 at 4:48 pm

    #1266095

  • RE: SPARSE vs XML vs EAV

    I don't like option 1 because you can almost always have a scenario where the requirement exceeds the sparse columns defined (unless you define a large number of columns which...


    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]

    December 23, 2010 at 4:26 pm

    #1266092

  • RE: SPARSE vs XML vs EAV

    In that case, I'd still go with the XML column. Index it, so it won't be that much of a pain to query the data. And make yourself familiar with...


    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]

    December 23, 2010 at 3:47 pm

    #1266083

  • RE: Stacked Column Chart - Incorrect Aggregate ???

    The good part of it: you catched it before the Holidays. So you don't have to worry about it anymore. And I'd be surprised if there would be a single...


    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]

    December 23, 2010 at 3:14 pm

    #1266075

  • RE: Time Worked in 15 minute increments

    I just tried the following sample code:

    SELECT CONVERT(datetime,'12/05/2010 9:30:00.000') AS 'TheTimeIn',

    CONVERT(datetime,'12/05/2010 9:35:00.000') AS 'TheTimeOut'

    and it returned 0 HRS, 35MINS and 30 AwardedMinutes.

    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]

    December 23, 2010 at 3:05 pm

    #1266074

  • RE: Table designed check for FAST SELECT Speed

    Digs (12/23/2010)

    Thanks good advice..:-)

    How does one rebuild an index..??

    and YEs the symbols are out of order, but dates are not !

    Have a look at BOL, section "reorganizing indexes".

    You can also...


    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]

    December 23, 2010 at 1:41 pm

    #1266061

  • RE: Need a suggestion for using Nolock and Readpast

    A similar question would be the current design of the upload process. If it's RBAR based (any kind of a loop) there might be the issue right away.

    We'd need 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]

    December 23, 2010 at 1:23 pm

    #1266055

  • RE: Logic

    If it's an interview question, try to answer it by yourself and do some research on it.

    Post your answer and see what others think about 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]

    December 23, 2010 at 1:09 pm

    #1266049

  • RE: Table designed check for FAST SELECT Speed

    If you always need to search by Symbol and Date, change the PRIMARY KEY to [Date] ASC, [Symbol] ASC. I'd even recommend to makes this the clustered index (assuming 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]

    December 23, 2010 at 1:06 pm

    #1266047

  • RE: Transpose Verticle to Horizontal

    As an alternative you could use the CrossTab syntax as described in the related article in my signature.

    If you'd need to add some flexibility, use DynamicCrossTab (a related article 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]

    December 23, 2010 at 12:51 pm

    #1266045

Viewing 15 posts - 2,326 through 2,340 (of 5,502 total)