Sparse columns are only good when you have a very high number of rows with a null value, those percentages are to low (that is if it is 0.64% and...

Lots of things can affect the plan.

Are the two servers exactly the same hardware specification?  Same CPU, RAM, Disk, IO.
Are you using the old cardinality estimator on...

Is the free space in the data or the log file?

If its the log, what is the status of log_reuse_wait_desc from sys.databases?

If its the data file,...

So from that the INT column must be maxed out at 2147483647?

If so then yes you will need to switch it to bigint, if not then you've got...

You've hit the triple hop problem.

You need to ensure that the two machines have SPN's registered and the service accounts are trusted for delegation.

That way the...

vino

Have you set the publisher failover partner and all the other settings to make replication work with mirroring?

The Replication&DBM doc is a great read for this sort of...

ASK SSC Topic

moving over here as this is more of the discussion forum rather than ASK SSC.

So if all you want is a readable...