oh - also

the state of those conversations

state_desc: DISCONNECTED_INBOUND

i think (and i may be incorrect) that the initiator of the conversation is not closing the conversation - which is...

bingo - here is your problem

your service broker conversations are not being closed, this puts memory pressure on and forcessql to dump these to tempdb - sql does not know...

i...

i really would avoid approach 2 - this might make querying easier for now, but someone will change the reports later as "new requirements are added" and maybe this table...

HowardW (5/18/2012)

---

AlAndrew (5/18/2012)

---

michael vessey (5/18/2012)

---

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where...

yes - sorry - a typo on my part

http://www.brentozar.com/sql-server-training-videos/

brent ozar does some excellent video podcasts - http://www.brentozar.com (i think)

acorrei1 (5/18/2012)

---

Trying to do a DR test. The file did exist but got deleted. I'm trying to recreate it.

GO

ALTER DATABASE tempdb

ADD FILE

(

NAME = tempdb_data_04,

FILENAME = 'x:\xxx\xxxx.ndf',

SIZE = 2MB,

FILEGROWTH...

if @sync_type initialize from backup is not the correct one, then it will be @sync_type='none'

see books on line

http://msdn.microsoft.com/en-us/library/ms181702.aspx

hiren.patel 911 (5/18/2012)

---

michael vessey (5/18/2012)

---

hiren

i have done this before - there is an option that you can use, but it depends on how much of the data on your POS...

with X (schemaname,tablename,recordcount)

as

(

SELECT s.Name AS SchemaName ,

t.Name AS TableName ,

SUM(p.rows) AS RecordCount

FROM ...

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where userid=x.userid and age is...

hiren

i have done this before - there is an option that you can use, but it depends on how much of the data on your POS server is replicated back.

you...

also try looking to see how many conversations are still open

select * from sys.conversation_endpoints

maybe your application is not closing the conversations after the messages.

since you've got nothing on the queues,...