lynn beat me to it again

declare @TimeInterval int=1

declare @dt_Start datetime

declare @dt_End datetime

exec pr_GetLastInterval]

@TimeInterval,

@dt_Start OUTPUT,

@dt_End OUTPUT

select @dt_start,@dt_end

the first one orderd by to.date of call - if there are multiples at the same time then it will depend on the internal storage in the table t0

if there...

Geoff A (5/16/2012)

---

you say the other server in another state is for DR.

why would you use replication? database mirroring could provide DR for you across the WAN.

do users in the...

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...