That's the general idea. The pagefile helps swap out physical memory and if you have high pagefile reads/writes and memory reads/sec along with disk activity, you can be seeing memory...

I can appreciate people getting upset, but this is inappropriate and I will remove and ban members that resort to name calling.

Andrew,

You can make your point without insulting someone...

You don't need to create a new db, but when you restore, you need to change the name at the top and on the 2nd tab, you need to change...

Be sure you document things well so others are aware they need multiple files to restore.

The 914 is great, and up for sale! First $3k or better gets it.

Not sure. In prior versions you couldn't grant execute to future procs. Looks like it's changed in SS2K5.

Feel free to suggest additions/changes to the level.

I had to pick some, and tried to make them fun, based on my love of baseball. Open to other suggestions. 🙂

Clocks get out of synch because the crystal drifts. The internal physical hardware just isn't precise.

That's why you want a "time server" that you sycnh all servers to. They'll correct...

Yeah, search is causing issues. I thought disabling the forum internal search would be good, but I'm not thrilled with Google.

Might change that back. Worth talking about.

Can you post the query and which columns are indexed on which tables?

Could be a valid run time, or could not. Hard to tell.

Look in the plan for table scans,...

Indexes are updated automatically as data changes. You do not need to do anything here.

You should have auto-update statistics on.

Run dbcc checkdb (includes checktable) at least weekly to look...

I used to also keep a branch in VSS that shows what's being deployed at any point in time. So once you've decided what needs to move, branch (copy) that...

Typically you do not want 2 FKs to one table. I think there's a concern that this will create a loop with tableA referencing TableB, which references TableA for some...

Thanks for the feedback and I understand.

The podcast follows the editorial, so if you get the editorial, then you have an idea of the subject.

What other data are you putting in these tables? It might be that they should be the same table?

You shouldn't need the FK if this is a 1:1 as mentioned...

There isn't another way, and the way to do it is script out the removes, the alter of the function, and the adding back of the constraints and put it...