I think I just answered this in a different forum. If so, please don't cross-post.

Run a trace (Profiler can help with that). Books Online has all the data on setting that up.

GilaMonster (7/15/2008)

Probably. This isn't the first time Mike's posted...

I could be mistaken, but all you need to check for compatibility is usually the structure and code. So, run Tasks\Generate Scripts... on the database. Script all tables,...

I've been a professional editor and proofreader, and managed and office of such. It's really only critical when it reduces the ability of the reader to understand what the...

Okay, I'm addicted to SQL or something. I read the title of this thread, read the first post, and the first thing that popped into mind was that the...

This Solomon name on each table looks very familiar. Did I do something else with this database a while back?

Use the Script Database tool to build a create script for all procs in one document, search-and-replace "Create proc" with "Alter proc", add "Set Nocount On" at the beginning of...

I have to ask, why is this a cursor? Why not a set-based upsert?

Maybe you could copy the databases to an instance of SQL 2000 and run it on there?

3

How much data do you expect to need to cache, and how many execution plans?

It's really not a "rule of thumb" kind of thing. It depends too much on...

1 Terrabyte

To be serious, you need to look at what is going on in your particular database. It varies from database to database.

For example, a large data warehouse in...

I just tried this, and Alt+F1 did absolutely nothing that I could see in Management Studio. If it runs sp_help, it did so invisibly.

(Does this mean I have to...

Not sure what you mean about partitioning a data file based on date, as opposed to partitioning data in tables. The only thing in data files is tables.