Forum Replies Created

Viewing 15 posts - 91 through 105 (of 428 total)

  • RE: How do I determine what process causes a lock with request_session_id = 0?

    Thanks Grant. Using the transaction id (from sys.dm_tran_locks.request_owner_id) I could figure out that the same transaction also had an IX lock on an internal table called "queue_messages_180220113", which is likely...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 16, 2012 at 1:28 am

    #1526353

  • RE: Slow performance

    gdraghetti (7/24/2012)

    Hi,

    I have a problem in SQL2005 so after several days of work without problems, suddenly takes a very slow (sqlserv.exe works much CPU in task manager) and checking the...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 14, 2012 at 8:07 am

    #1525533

  • RE: Slow performance

    Have a look at the state of the conversations in your system(s). Are they properly closed by a call to end conversation on both ends? A good starting point is...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 14, 2012 at 7:44 am

    #1525520

  • RE: I want to be able to stop my queue when there is a backlog...

    dave.farmer (7/26/2012)

    ...

    I'm also curious as to the operation of the RECEIVE... when there are, say, 10 million messages in the queue, what will my activation procedure actually RECEIVE? Not all...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 14, 2012 at 6:57 am

    #1525485

  • RE: I want to be able to stop my queue when there is a backlog...

    What I usually do in this sort of situation is simply to disable the queue (alter queue dbo.[queuename] with status = off). The call to receive will fail on...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 14, 2012 at 6:50 am

    #1525476

  • RE: recommendations for MAX_QUEUE_READER option on queue

    You may still be interested to read this blog post from the developers of SSSB which describes how to configure your service broker routes such that the calls to your...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    August 14, 2012 at 6:28 am

    #1525457

  • RE: Calculated column Only for Insert

    Then while you're at it, don't use getdate() for the timestamp on your audit data and don't use current_timestamp either. Instead I suggest to use getutcdate().

    Using getutcdate() ensures that a)...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    July 23, 2012 at 2:27 am

    #1516100

  • RE: Eliminating Duplicate Rows

    prakashp 84206 (6/6/2012)

    R.P.Rozema,

    I want to remove the duplicates as a one-off task.

    Since you're talking with MS SQL experts here, I would like to suggest you import the data into a...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 15, 2012 at 1:29 am

    #1501421

  • RE: Eliminating Duplicate Rows

    Ok, lets go about this another way: do you need to remove the duplicates as a one-off task, or are you writing some code that will be used many more...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 6, 2012 at 2:30 am

    #1497454

  • RE: Eliminating Duplicate Rows

    That's not SQL J, that's Sybase Adaptive Server. As I read it, SQL J is just a method to include Java code in their database, much similar to SQL server's...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 5, 2012 at 5:01 am

    #1496971

  • RE: Eliminating Duplicate Rows

    prakashp 84206 (6/4/2012)

    Dear R.P.Rozema,

    I understand your concern, don't get angry. Sorry for troubling you. But frankly speaking I can't find the forum for SQL J. I am using SQL J...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 5, 2012 at 12:59 am

    #1496917

  • RE: Eliminating Duplicate Rows

    prakashp 84206 (6/4/2012)

    Thanks for helping me. But 'ROW_NUMBER() Over' function is unknown in SQL version I am using (Gives error message). What is alternative solution to this problem. Any simple...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 4, 2012 at 6:55 am

    #1496456

  • RE: for xml path() concatenates texts, how to get 2 elements with the same name?

    iBar (5/23/2012)

    Agree. Ok then "Mark-101232" solution is already there.

    Thanks.

    Thank you for the effort, but I wasn't looking for an answer anymore. Microsoft already provided the 'official' workaround: select

    'A' as [value],

    '',

    'B'...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 3, 2012 at 4:08 am

    #1496270

  • RE: FOR XML returned as result set instead of one stream. Alternatives?

    You can also give this a try to see what it does for your performance. It would do a lot better if at least some of the columns used in...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 3, 2012 at 3:41 am

    #1496265

  • RE: FOR XML returned as result set instead of one stream. Alternatives?

    GSquared (5/30/2012)

    Those IsNulls in the Where clause and Join predicates are also going to also kill performance, unless I'm mistaken. Regardless of indexing.

    ...

    Indeed, the isnulls should be removed to...


    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]

    If you don't have time to do it right, when will you have time to do it over?

    June 3, 2012 at 3:21 am

    #1496263

Viewing 15 posts - 91 through 105 (of 428 total)