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

Jeff Moden (8/2/2011)

---

Leo.Miller (8/1/2011)

---

I can't see any real benefit of using an iTVF, since as far as I can see, [font="Arial Black"]you can still only pass it a single paramater[/font],...

I'd go for Option 4..

Install Instance2

Script all logins, linked servers, jobs, operators, etc on Instance1

Recreate logins, linked servers, jobs, operators, etc on Instance2

Backup and restore (with no-recovery) databases from Instance1...

I can't see any real benefit of using an iTVF, since as far as I can see, you can still only pass it a single paramater, even though it returns...