Using brain dumps is considered cheating and if MS becomes aware of it, they will revoke all your certs and put a lifetime ban on your account.

If you want the...

I'd suggest you run profiler and catche the deadlock graph event. That will give you a graphical view of what was caused the deadlock, both the one that was picked as...

At their simplest, statistics tell the optimiser the distribution of data in a column (or a set of columns). It can help the optimiser know how many rows to expect...

 I am just curious how much time and effort I should put into some of this or if I should just "put my faith in Microsoft" and that DTA knows...

For instance I dont want to have to prepend all the tables in my query with the fully qualified name.

Why not? Unqualified naming can lead to slower queries and unnecessary...

SQL unfortunatly likes to be on a server of its own. It doesn't like sharing resources with anything. It could be worse. I've seen someone put SQL on the same...

Having SQL Server on the same machine as exchange server is not a recomended practice.

See if you can find out how much memory SQL is using and how much exchange...

I would suggest running it with the execution plan on, as well as the IO and time statistics. That way you can work out which of the queries are the...

Sounds like a good candidate for transactional replication.

Then partition them. Use whatever parition scheme makes the most sense for the tables

They don't all have to have the same partition function. Related tables don't have to be correlated.

Rob, sounds like you need some on-site help. Whereabouts are you based?

So why don't you come back?

The MSDE box was a test box not the production box. If tou read the first post, he is using SQL 2000 sp4 as the production db

Ah, sorry. I misunderstood. I thought you wanted to convert three tables into 1 partitioned table.

As I said before, the examples may show partitions done on datatime columns, but you...

I think you've misunderstood partitioned tables.

Partitioned tables are for when you want to split a single table into pieces either for IO performance or for fast loading and deleting of...