Don't know why this popped up first with today's date. I enjoyed, but thought I'd comment.

I'd like to see more realistic numbers for a production database. Autogrowth at 1 MB...

We do live in a 24 hour world. Of course, if you can buy and sell a currency at the same price throughout your business day (assuming no commission), there...

Since

Of course, if you have many thousands of records, you'd need to define some more detailed rules.

I'd be looking at some data entry to fix the dataset.

I think it's a template for Profiler that can be imported. It only shows settings for a trace.

Is this homework? Post requirements doc for quote.

"The following figure shows the estimated query costs for the Production.ProductVersion2. The subquery implementation took 43 seconds to complete where as the ROW_NUMBER() implementation took 5 seconds to complete...

12 or 24 hour clock?

Check out the tools from OpNet Technologies. Useful info for application and network layers when the finger pointing starts.

I forgot my standard caveat of testing and benchmarking thoroughly before and after any changes and prior to moving to production.

There may be some crossover among the different network layers here. Network vendors are partially responsible. Some use frame, packet or MTU interchangeably.

Ethernet is at the physical network layer and...

So, if I understand correctly, you want to "copy one database table to another DB table" without telling the system how to do it? Let me know what you find...

Thanks, Gail. Excellent nuts and bolts foundation. Perhaps you could cover statistics one day and how they relate to indexes.

In general, I setup what's currently in production in both development and test. However, it would be nice to say "I'm xx% complete in my testing of SP3." when someone...