Then what are you averaging by?

As far as I can tell, it's reading in chunks because that's how it transmits. It's part of the multiform / data-part thing. But again, I got this code from...

I just posted an issue with a VB Script Task (SSIS) and would appreciate the thoughts of anyone with experience.

My in-house Dev is telling me I can't do this...

Nevermind. I finally got my google-fu working (needed to look for "orphaned file", not "phantom file"). The solution is here: http://connect.microsoft.com/SQLServer/feedback/details/482820/orphaned-log-file-can-not-delete-log-file-sysfiles1-duplicate-namesnd%20259164%20(Denali)

As Megha said, grab the count of your files.

--You only need one DECLARE statement

-- and you can assign the values within that statement too.

-- Saves on typing

DECLARE @current_date DATETIME...

If you need to do this as a Stored Procedure, all you have to do is get a Linked Server from the other server, then do a LEFT OUTER JOIN...

If you have the money to invest in high availability options, you should. Clustered servers, mirrored instances, etc. are all good options for mission critical databases. And, as Grant said,...

Pat, you misunderstood my problem. We had all the timeouts maxed out or set to 0 for no timeouts. Despite this, we were having problems with the timeouts.

I'm not sure...

Jeff Moden (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would probably work...

What are...

qew420 (4/21/2014)

---

Some tables are huge also but still all was good before adding replication

...

I can check the missing Indexes but again only counting the # of records .. system...

*THAT* is a filleted fish?

Ummm, would you take it the wrong way if I begged you to keep your day job and forget about opening that restaurant? @=)

It doesn't matter that everything was good until Replication was added. When you added Replication onto the server, you added an extra load plus you added a whole bunch of...

Hey, run this script on the Subscriber and see if you're getting lots of small waits or some (or lots) of long waits. Post the results, please.

select * from...

:crying:

Why, oh why, oh why do people insist on pulling scripts off the internet then asking us to modify them to do what they want the scripts to do without...