i think this might answer your question

Update b

set b.run_daily_avg_consum = cast(a.run_daily_avg_consum as decimal(15,5)) *.7 + b.Daily_avg_Consumption *.3

From [Stage1W_Dim_Readings] a inner join [Stage1W_Dim_Readings] b on

a.pod_no = b.pod_no and a.Read_Seq_Pod...

beware of using syscomments for this - you can get more than one row and the keyword you look for can be split across 2 rows

i would recommend finding them...

that looks interesting

ryan - i beleive that is your only way - sql is trying to create the tempdb files when it starts and it can't, so it shuts down.

as far as...

MisLead (5/15/2012)

---

Does anybody no sql command in ADO.NET connection support "order by " clause or if there is a work around for it. I am trying to avoid ...

ive found the easiest way to do this is to mount a new drive with the same drive letter as the failed one.

then boot sql server and modify the...

a usefull insight into the impact - there are many detailed articles on this, but none that are as simple and clear....

one thing you missed though... your server has...

just an update

after some testing we have adopted a different approach - it wasn't service broker that was the problem (as mentioned in the previous 2 posts)

the 64 bit...

it's not been implemented by quantix has it ?

i think i hit the jackpot

http://msdn.microsoft.com/en-us/library/dd576261(v=sql.100).aspx

finally after 2 days worth of digging 😀

i did find this interesting snippet

http://datageekgal.blogspot.co.uk/2008/07/sql-server-service-broker-archival.html

ARCHIVAL TIP #5: TUNE THE NUMBER OF QUEUE READERS

I've yet to find a solid recommendation for choosing the number of queue readers (threads) to activate...

thanks for the reply lynn

i have to assume that the files will be constant and a 24*7 basis, and that the number of files will be more than a single...

its an old script from sql 2000 days - sorry

lookking at it now

Lynn Pettis (5/14/2012)

---

Going with the "it depends" answer. How many files are being processed, how often are they processed, how big is each file that is being processed, how...