Locks aren't always just for the rows affected. Often, with updates, inserts, etc., they can spread to pages, extents and even the whole table. Depends on how much...

You might be able to do it from a UNC path to a shared directory on the network, but it often bombs out.

Can you clear out some space on the...

I have this horrible thought about SQL in spandex stuck in my head now. Yeah, I know, it's not quite what was written, but it sure is what my...

That, I can't answer.

My application was an Access project on an SQL database. No Access database, no linked tables, etc. Never had to deal with those.

Hopefully, someone else...

I've had problems with that with VPN. Same thing a couple of times with remote desktop connection to my desktop machine. It's an on-again-off-again thing for me in...

Are you sure you want clustering? You mentioned that the servers are in a DR site, and that usually means "disaster recovery" (at least to me). That's not...

Yeah, but it's already been said that it's...

The easiest way is usually to set up a linked server. There's a section in Books Online about how to do that.

select *

from #PointTable PT1

inner join #PointTable PT2 -- Second failure

on PT1.PointName = PT2.PointName

and PT2.DateValue between

dateadd(minute, 14, PT1.DateValue)

and

dateadd(minute, 16, PT1.DateValue)

inner join #PointTable PT3 -- Third failure

on PT1.PointName =...

Jeff's article on running totals is at: http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

You could do:

SELECT Top (1) CASE ENCT_HDR_BATCH_ID

WHEN '837P'THEN 'M'

WHEN '837I'THEN 'M'

...

You have two connections looking at the same table. Each generates a Share Read Lock. If they both lock the same row, you'll get two. This is...

More important than the backups, it sounds like you have the log files on the same array as the data files. Is that correct? If so, you'll want...

I think I solved that once by changing something on the form/report in Access, but it's been too many years for me to remember what it was. Is there...

You could run the data through a proc that would split it for you. Would that solve your problem?