Another solution would be to set all the queries to use WITH (NOLOCK)

select * from Test1 with (nolock) where ID_Col = 10

But I would consider this a bit of a...

Yes.....

But I assume you want more than this..:-)

On one connection do the update - This was my test

begin tran

update Test1 set First_Name = 'Test1' where ID_Col...

10 named instances, one for each application database seems a bit over the top. That's a fair bit of admin you would be adding for each application. I'd recommend some...

We bounced this arround in the office and one option would be to allow the second process to READ UNCOMMITED transactions. We are assuming this is a controlled, test environment,...

There should be a "From Address" on the mail....

This is one of the possibilities told...

Be carfull of using sp_spaceused. If your statistics are out of date, the table sizes may not be correct.

Leo

Since it happens every minute it sounds like it's the actual pull process that is failing. Have you looked at the relevant stored procs to make sure they have created...

Did you ever find anything causing this? I've got a client of a partner company with the same problem, also on a NAV database.

One question though, since it's the user...

I suspect much of what you will hear about this will be opinion.

There was a time when mount points were considered bad practice, but if you talk to the Unix/Oracle...

I've run some tests ranging from a few hundred rows to a few million rows, and in most cases using the inline case is more efficient than passing the table...

Matt Miller (#4) (8/3/2011)

---

This was changed in 2008 (R2?). You CAN create a function taking in a table parameter.

See the BOL entry here for the specifics. It's definitely...

Either of those would do. I'd prefer the first one and RAID 10 over RAID 5 if space isn't an issue. The read/write ratio is handy, but do you have...

Ninja's_RGR'us (8/2/2011)

---

Actually...

Dump the main query into a temp table.

Put a synonym on it.

Call the itvf and use the synonym and use that to return the final dataset :alien:

http://www.sqlservercentral.com/Forums/Topic1145600-2965-1.aspx#bm1149754

So in essence...

I would definitely test this before I did it for live. If you follow Option 3 with the log shipping you can change the server name to something other than...