Both queues (source and target) have activated procedures to process messages.

DugyC (3/1/2011)

---

Ack! Got it wrong, slightly, but enough to lose the points! :ermm:

The explanation I found in this article http://sqlserverpedia.com/wiki/Heaps under heading Forwarded Records said... Any non-clustered indexes on the...

They're just different instances on the same server cluster.

The actual plans used (according to SSMS at least) match the estimates in both cases.

So let me get this straight... because I knew how the function worked, I am wrong.

Had I not known how it worked, I would have had a pretty decent chance...

paul.jones (11/12/2010)

---

OK, I'm happy with the explanation of why COALESCE fails, but why does ISNULL work? vk-kirov observed that ISNULL(NULL,NULL) appears to be a NULL of type INT, but it...

Sorry, I'm afraid I don't understand the point of the question.

Is it a trick to fool you into thinking the += compound operator? Or perhaps a typo when += was...

Hugo Kornelis (10/19/2010)

---

Only if they are indexed. Or if the relationships between the underlying tables are such that you can derive the number of rows in the view from the...

Thanks for this one - lots of stuff I didn't know there.

Does anyone know if there's a similar fast count method for views? I have a health check procedure which...

So many different solutions... suggests SQL should have a proper case function of it's own?

Many moons ago I came up with this - our need is quite straightforward, lower case...

Another dumb trick question 🙁

I use connection colouring, and it always works, so I was tricked into thinking the question was about that, hence answered 'True'.

I don't mind getting an...

No-one seems to be mentioning the elephant in the room here...

If we auto-generate the database and do all the work in higher tiers, what happens to SQL developers? We...

...and the point is...?

Not a test of anything as far as I can see. If I add unwanted punctuation my mistake I get an error and remove it, I'm not...

daniel.paul1986 (6/22/2010)

---

Hello All

I am over here to tell that i am new to working with oracle programming language. Well i had some basic related to C,C++ and Java. So could...

dave.farmer (6/18/2010)

---

I tried to replicate this (in SQL Server 2008), and I didn't get a unique constraint violation, I got

"An explicit value for the identity column in table '#fred'...

I tried to replicate this (in SQL Server 2008), and I didn't get a unique constraint violation, I got

"An explicit value for the identity column in table '#fred' can...