I would suggest you follow the suggestion to unistall the native client and try again.

The exact same code to format it for both on the SQL Side? Not really, the best you could do is write your own formatting function for each and...

If you want students to learn how to use "UNION", especially to create a third table, then start with 2 tables that have more in common than the 2 listed...

Let me guess UoP (I used to teach the SQL Class)...

You need to match the datatypes including sizes.

One thing that has come to mind is (and it may have been the OS2 version) you had to reboot it every 6 weeks or so because something would overflow...

One way is to find a couple of good SQL Server programing blogs and just read them.

Also the SQL for smarties books are a good source even though they...

You could try looking for old sybase documentation. Sometimes with 4.2 and the older versions the sybase doc was a better place to go than the Microsoft documentation.

I may...

800 GB isn't so big that you can't back it up more often. I have large DBs I do fulls on nightly with Red Gate. Then again I have...

Have you looked at Red Gate or litespeed?

The quickest way would be to do it from Mgmt Studio and instead of clicking ok use the script option to script it out.

have it unzip it to a defined location and name them write a SQL command restore

Restore ....

Then put that in as a SQL task or define it with an OSQL...

Any specifics on your error message and/or anything in the SQL Server error log?

Try looking at the details of the job, it should show you an elapsed time...

CPU time is not the only metric, don't forget I/O as well. Have you tried looking at the actual query plan (not the estimated one) for the query...

Try checking Dell.