Forum Replies Created

Viewing 15 posts - 961 through 975 (of 5,502 total)

  • RE: "Broker Transaction Rollbacks" Performance Counter

    Here's what Rusanu answered:

    Some internal tasks follow a pattern of starting a transaction, looking for work to do, exit if no work. When they do so they are causing 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]

    September 16, 2011 at 9:18 am

    #1382615

  • RE: using @variables in sql programing

    What exactly is the problem? Is there any error message?

    What is the output of select * from @qtttab in the "problem section"?

    If there are more than one row in @qtttab...


    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 16, 2011 at 6:39 am

    #1382509

  • RE: "Broker Transaction Rollbacks" Performance Counter

    As per Remus Rusanu the increase of the counter is harmless and is no indication of a problem. Once I have permission I'll post his reply.

    His explanation and what you've...


    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 15, 2011 at 1:03 pm

    #1382230

  • RE: MONTHS AND QUATER

    komal145 (9/14/2011)

    I have to do something in report using this table.

    That doesn't really answer the questions.

    There are several things wrong with the table design as well as the concept in...


    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 14, 2011 at 2:38 pm

    #1381618

  • RE: Merge Multiple Records into one w/o Cursor

    Just leaves a few more questions to answer 😉


    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 14, 2011 at 1:20 pm

    #1381581

  • RE: MONTHS AND QUATER

    What exactly is your question?

    And what is the purpose of this table? To me it seems a little strange....


    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 14, 2011 at 1:18 pm

    #1381580

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/14/2011)

    Changing the topic for a moment, I'd like to beg some ideas from the group, again.

    I'm tasked with writing another article. This one is all about the scary,...


    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 14, 2011 at 1:13 pm

    #1381576

  • RE: Merge Multiple Records into one w/o Cursor

    First of all, please provide the table def for #CustomerInfo so your script can actually be used (we would have to guess the data type you're using).

    Also, please note that...


    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 14, 2011 at 1:07 pm

    #1381570

  • RE: Display Column Name verticly

    Unfortunately, the dummy data are still not valid.

    But here's an example of what you might look for (as a side note: please notice how I present the sample data...


    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 14, 2011 at 10:02 am

    #1381440

  • RE: Are the posted questions getting worse?

    ALZDBA (9/14/2011)

    We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!

    http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/

    Congratulations Jeff !!

    Very well deserved, Jeff!!

    Thank you for you continous help. I've learned a lot from your posts and...


    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 14, 2011 at 7:29 am

    #1381286

  • RE: How to write a sql query for select statment when number of columns changing dynamically

    Please be a little more specific.

    Usually, you would use SELECT col1, col2 ... FROM YourTable.

    But that sounds too basic to be the question here... Or are we talking about homework?


    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 14, 2011 at 5:10 am

    #1381174

  • RE: how to achive when all the row comment need to updated in single column in sqlserver 2000

    Unfortunately, SQL 2000 doesn't offer that many options.

    One solution I can think of is to use a function.

    An example can be found at Adam Machanics blog


    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 14, 2011 at 2:00 am

    #1381098

  • RE: pivot data pairs SQL 2005

    David Walker-409102 (9/13/2011)

    Thank you, Lutz for your quick reply. I'm reading the two articles on cross-tabs and they look promising. I'm not sure what you mean by having...


    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 14, 2011 at 1:11 am

    #1381085

  • RE: Advice on running totals using a cursor

    Jeff Moden (9/13/2011)

    Oddly enough, it wouldn't take much more time to do the Quirky Update on a million row table than it would be to go through all the shenanigans...


    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 14, 2011 at 1:03 am

    #1381080

  • RE: pivot data pairs SQL 2005

    Please have a look at the CrossTab article referenced in my signature. This concept will work if you have a known number of comments. Otherwise you might want to read...


    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 13, 2011 at 2:25 pm

    #1380916

Viewing 15 posts - 961 through 975 (of 5,502 total)