on this topic.

If I lay down a Ghost Image from a month ago of just the C: drive - which had no .MDF or .LDF files, will any databases on...

Yes.

I made a call to Microsoft on this today actually. They said that the COM and TOOLS directories have to go on the C: drive. These folders are shared files...

What is a "3 part name"?

Also, what is the order of search that SQL Server does for stored procedures?

(For sp_ and all other naming conventions.)

if you use AWE remember that SQL Server will hold on to the setting in MAX SERVER MEMORY for each Instance.

Not dynamic memory allocation here.

so in a case-insensitive environment both should register a cache miss hey.

Is this the same in 7.0 and 2000?

Is this the case for SQL Server 2000 also?

good point.

but is it possible to back up to a mapped network drive?

network share?

ya I will try and test also and post results.

If you get more information on this I would appreciate it.

(Send me an email if you can.)

ya I asked this before but I did not get full agreement in responses.

So when a Full backup runs it marks the commited sections of the TL as inactive which...

Factor in that for Ad-Hoc statements, when an execution plan is compiled the plan is saved to cache along with a cost factor associated with it. This value is set...

From bkelly:

"If, when you run a trace from the client side you don't see anything saying something to the effect of "Some events may not have been captured" your client...

Since we are on the topic,

Backups:

Day 1: Full

Day 2: T-Logs Only

Day 3: Full

Day 4: T-Logs only

Will this restore process work:

1. Apply Day 1 full

2. Then Apply Day 2 T-Logs

3. Then...

Thanks for the info.!!!

One more quick question:

In SQL Server 2000 E.M., if the Full Recovery model is selected and there are hourly t-logs backups being taken for example. If go...

I will be selecting this option during my stress tests since any profiler data loss will affect my reports.

Just wondering on a higher level how much this option will affect...

I am wondering about the extra processing needed due to selecting "Sever processes sql server trace data".

(CPU mainly).

It seems that running a Stress Test against a box that must also...