The best starter and foundations of Service Broker articles I've seen are Adam Mechanic's.

http://www.simple-talk.com/sql/learn-sql-server/service-broker-foundations-workbench/

As Jeff mentioned above, that particular question is a trap. It implies...

biju.pad (11/5/2010)

---

1. Relevant Pages of the index are brought into memory. Because the leaf nodes have data pages, I am assuming index sizes are much bigger and more I/Os are...

biju.pad (11/5/2010)

---

I thought non-clustered index had the RIDs of the actual rows, whereas clustered index stored the actual row as leaf nodes. It is precisely because of physical ordering that...

Lynn Pettis (11/5/2010)

---

tosscrosby (11/5/2010)

---

ALZDBA (11/5/2010)

---

Jack Corbett (11/5/2010)

---

Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER...

Much luck, Roy. May your rain be soft and pretty, instead of sideways and flipping trees. 😀

On a lighter note, I made into the top 5 posters for...

Hey Lutz.

Yeah, found the 'Monday' equation, which is how I think I went flying up the wrong DATEFIRST when I did a little research behind it on the web. ...

Jeff Moden (11/4/2010)

---

Setting DATEFIRST in a query only affects the session, not...

Perhaps something like this?

select

o.name,

i.rowcnt

from

sysobjects o

JOINsysindexes I

ONo.id = i.id

where

o.type = 'u'

and i.indid IN (0,1)

order by

o.name

PFlorenzano-641896 (11/4/2010)

---

ADM User: Labrie

ADM Item Removed (Override) - Fondaparinux 2.5 mg/0.5 mL Syringe; (see order detail)

ADM User: Labrie

ADM Item Removed (Override) - Clopidogrel 75 mg Tablet; (see order...

Once more for the other field then, (Sorry about the non-encoding, my browser's having issues today)

SELECT top 20 tud.Value

FROM cv3taskuserdata tud

WHERE ISDATE(tud.value) = 1

SELECT top 20...

Whoops, well, answers one question.

Another try for the first query, please?

SELECT top 20

oto.performedfromdtm

FROM

CV3OrderTaskOccurrence oto (nolock)

WHERE

ISDATE( oto.performedFromDTM) = 0

AND oto.performedFromDTM IS NOT NULL

Can you show us the output from these queries, please? It'll give us an idea of what the data looks like in the column.

SELECT top 20

...

Greg Edwards-268690 (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

GilaMonster (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Nah - do...

Use a higher precision numeric/decimal then you're going to display as. For an example:

DECLARE @n1a NUMERIC (25, 8),

@n1b NUMERIC (25, 8),

@n1c NUMERIC (25, 8),

@n2 NUMERIC (20, 4),

@n3 MONEY,

@n4 NUMERIC...