What exactly did you change?

See if this helps

http://msdn.microsoft.com/en-us/library/ms171744%28SQL.90%29.aspx

My initial settings are the default ones, 8MB for the tempdev file and 1MB for thelog file. The autogrow is of 10%.

Currently, the tempdev file is of ~792 MB...

Reo - in fact I want to increase the size of the tempdb files (data & log). It seems that the tempdev file needed to grow, and hence an warning...

Can you attach a sample of your data file?

Also you can try to use a format file and skip the null columns.

Did you updated the statistics after upgrading?

I hope that the below links wil help you:

http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/bb6bed9d-a236-41af-a54a-37f434c6a074

See BOL ---> Batches - CREATE VIEW has to be alone in its batch...

Store the Courses, Credit Types and States in separate tables.

Create a CreditTypeByState table (StateID, CreditTypeID) to store a credit type - state correspondence. Use CHECK constraints to allow only the...

You're welcome.

The description I talked about is not taken from the MSDN link you mentioned. By the way, in my opinion the MSDN documentation is weaker and weaker...

This is a...

You can see its description in the "performance monitor":

"Working Set is the current size, in bytes, of the Working Set of this process..."

Check the connection string to the remote server. Does the user which connects have the necessary privileges?

Thanks, that's what I'm doing...

Happy hollydays 🙂

Export the table (*) in a .csv file using the bcp utility (see BOL), copy the file to the NY location and import the data in Access.

* I understand that...

See BOL ---> Collation Precedence

This may be a permissions issue, depending on the user logged in - see the "permissions" section in BOL ---> sys.databases.