Only other one would be to test your TTL on the DNS entry, you will want to flush your DNS cache on all machines so that it picks up the...

One of the job steps isnt trying to recreate the job is it?

Probably calling a SP which creates it then runs it.

With the apps still running.

That way its a true representation of a unplanned fail over.

If the apps are not cluster aware then stopping them for a planed fail over isn't...

Would all depend on the DDL of the users table?

Do you know what this is? Can you provide it along with sample data, indexes and how your data loads...

Put the file on the SQL servers E drive. Use UNC shares instead ensuring that the SQL service account has the necessary rights to read from the share

Not a...

Does that file exist on the SQL servers E drive?

This is not with IIS its with SSMS.

Open SSMS on my desktop, connect to ServerA, then use linked server on ServerA to talk to ServerB getting the kerberos issue.

Resolved this...

Yes, the computer account and the service accounts are set for delegation.

MikaS (8/5/2014)

NO!

Full backups do not and never have broken the log chain. The reset the differential base, that is all. Copy_Only allows for a full backup to not reset...

Depends on what type of app and/or the amount of users.

If its a web based application, then you cannot say how many people are going to be using the software,...

Then you need to order the results and select the top X amount

SELECT

*

FROM

Property

WHERE

Beds = 2

AND

Location = 'XYZ'

ORDER BY

Baths DESC, -- more baths the better

Price ASC, -- less price the better

Parking...

Ok the next step would be to post the actual execution plan once you have got it.

Have you rebuilt all your indexes and statistics since the upgrade?

If not I would do that before you do anything else

Please provide the actual execution plan

Is that the estimated execution plan or the actual execution plan?