The same thing happen with text field, switching to varchar(max) fixed the problem.

I guess if you switch to varbinay(max) your problem will also be fixed (you still need to reindex...

I heard magic fairies were very good at boosting server performance by 100% - 200% each time... :hehe:

Easiest way to upgrade is a backup/restore and then change compatibility.

Test it first outside production to make sure there are not depreciated SQL used.

Since you are busy upgrading, you might...

Use bcp.exe to get data to the disk, the output of SQLCMD is not really meant to be processed automaticaly.

Can you find the query generating the error?

Yes if all you want if the FreeSpace (without total space).

If you really want to use SQL server you can use fsutil (in xp_cmdshell 'fsutil volume diskfree C:') to get...

What about the witness log?

It looks like the mirroring was broken a few minutes before the principal reboot, that explains why there was no failover when the principal rebooted (mirroring...

In short the collation tells the server how to sort character data (char, varchar, etc ...).

Changing the server collation is not easy, quickest way is to either reinstall the server...

I think Data Pump to bulk load stuff between Oracles instances, and SQL*Load to load data from a flat file.

Haven't tested so i'm not 100% sure, that's what the Oracle...

Have a look at SSIS, it should be the perfect tool for you.

The best way to fix your problem is to rewrite your initial query without the view and to simplify it as much as possible.

The more complicated a query is, the...

The easiest way is to run a trace on this user (loginname = 'domain\user'), in the trace you'll have a cpu, read and write column. That'll give you a prety...

What about ROUND(DATEDIFF(yy, PerBirthDate, GETDATE()), -1)?

The first line is not required (at least it's not the reason you forgot your password 🙂 )

You can also get rid of the MUST_CHANGE, since you'll be the one...

Its the SQL Server Service (usualy MSSQLSERVER or MSSQL$<instancename>), the SQL Server Agent is a SQL scheduler.