But if the network were at fault, wouldn't it cause all of the mirrors to fail over? We have other principals/mirrors set up on other servers, using the same...

Default.

Issue Resolved: as I expected, after increasing the size of the drive that the data file for TempDB is on, the job went back to running in 20 minutes...

OK, followup questions:

If I issue an ALTER INDEX REBUILD command with ONLINE=ON, and there is not enough disk space or memory to do it ONLINE, will the SQL Server then...

adb2303 (3/15/2012)

---

any changes to the environment or databases, i.e. LOB data, MAXDOP settings? Do you use SORT_IN_TEMPDB? Do you have an idea of what fragmentation was like before...

We already run the job during the period of lowest activity, but there is always activity. It is a 24 hour / day application.

How would shrinking TempDB beforehand help?

Basically my manager has issued me a challenge in SSIS. Given an Excel file, update the rows in a table by joining the file to the table via its...

I'm assuming that the source of the problem is becuase the Publisher is SQL2K5 and the Distributor and Subscriber are SQL2K8. To get around the problem we're just going...

Unfortunately not, its a production table.

orderApplicationReasonId

orderNumber

Reason

Roy Ernest (8/9/2011)

---

This happens only in this publication? Do you have a user defined data type in this table? I do not think it is the column name that is...