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...

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...

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...

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...

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...

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...

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)...

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

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...

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...

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...

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...

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'...

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...

Indeed, the isnulls should be removed to...