How did anyone get it right? Obviously I knew I'd be marked wrong as you asked for two answers and provided radio buttons, so I chose one of the right...

Ha ha, sorry George, much appreciated too 🙂

Aha! Thanks Gail, I didn't know about DATALENGTH! That was the tool I needed to get to the bottom of it.

Nearly all the space is used by the _FullCommand column....

I tried that originally, then rebuilt the index, neither helped.

CREATE TABLE [data].[Cluster_SqlServer_SqlProcess_UnstableSamples](

[Id] [bigint] NOT NULL,

[CollectionDate] [bigint] NOT NULL,

[_Blocked] [bigint] NULL,

[_BlockingLoginTime] [bigint] NULL,

[_Command] [nvarchar](max) NULL,

[_CumulativeProcessorTime] [bigint] NULL,

[_DatabaseName] [nvarchar](max) NULL,

[_FullBlockingCommand] [nvarchar](max) NULL,

[_FullCommand] [nvarchar](max) NULL,

[_LastBatch] [bigint] NULL,

[_LastWaitType] [nvarchar](max) NULL,

[_MemoryUsage] [bigint] NULL,

[_OpenTransactions] [bigint]...

No, it has a clustered primary key on two columns (both bigint), no other indexes.

Thanks Jim,

Anyone else have anything to suggest? There must be some Service Broker experts out there in this community?

My understanding (and if it's wrong, I'd be happy to be corrected):

The queue was not being poisoned. That disables the queue, which did not happen.

Also, poisoning happens because of errors...

Jeff Moden (1/2/2009)

---

battelofhalfwits (1/1/2009)

---

Wow...

Two things

1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where...

Thanks for that - excellent article.

When trying some of the examples in there, I...

Tom.Thomson (3/19/2011)

---

The question of date formats has come up a pretty large number of times in QoTD discussions in the last two or three years, and it amazes me that...

Koen Verbeeck (3/18/2011)

---

Chris Howarth-536003 (3/18/2011)

---

Depends on the language settings. I get the following error:

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime...

DNA_DBA (3/17/2011)

---

Good question. There have been a few Visual Studio questions recently - it's made me want to find out more about it as it could be quite useful. ...

Duncan Pryde (3/10/2011)

---

Jamie Thomson (3/10/2011)

---

The big benefits as far as I can see them are:

-Development-time error checking (i.e. find out about errors before you actually run the code - so...

I'm loving the reference to "Visual Studio Database Davelopment Tools"... that's how I shall think of it henceforth 🙂

Dave.