I guess the first is:

My computer->properties->advanced->performance->advanced

Have a look at

http://www.sql-server-performance.com/articles/per/advanced_sql_locking_p1.aspx

and http://www.sql-server-performance.com/tips/reducing_locks_p1.aspx

Failed to reserve contiguous memory of Size= 65536

Could be MemToLeaveArea is getting full. You can change the default from 256mb to 512mb with the -g switch

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1788.aspx

Overview of cumulative hotfixes for...

Have a look at:

http://www.sql-server-performance.com/tips/filegroups_p1.aspx

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx

You can use

DBCC DROPCLEANBUFFERS

Remarks

Use DBCC DROPCLEANBUFFERS to test queries with a cold buffer cache without shutting down and restarting the server.

and

DBCC FREEPROCCACHE

Remarks

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing...

Hello,

The latest articles recommend watching I/O latency performance counters instead of

queue length.

The high queue length can come of various reasons:

datagrowth, recent software update.

Have a look at

http://www.sql-server-performance.com/articles/audit/main.aspx (performance audit)

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

for...

Access saves the tabledefinition when it is first linked.

Any change in the defintion may result in #deleted entries or not showing additional columns.

Some access-programs have vba-code that drop the old...

It surprises me too.

In the definitions where-clause of the view is

where permissions(831458882) & 1 = 1

Still have to decipher that.

Select AcctNbr,SubAcctNbr

from dbo.AcctEntry --> has 700,000 rows

Could be a full table scan or an index scan (on AcctNbr,SubAcctNbr)

Fast server:

Could have had those data in cache before (more memory)

Could have an...

*be aware that SP4 needs a hotfix if you are using AWE-memory parameters

*SP4 has a behaviour change in deciding which index to use. With comparisions you have to match the...

The only thing I had to change on replication was the batch-size used by the agents because of a slow subscriber.

Have a look at the performance counter sql server target memory.

http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx

A restore normally restores permissions also.

Are you restoring to a single-user mode (restricted) or multiuser?

I had problems with permissions not being restored in restricted mode (only dbo permissions remained).

Can you find the specific error?

It only starts deleting files after all the backups were succesfull.

is a hard limit in msde 2000

http://www.petefreitag.com/item/194.cfm

sql server 2005 express doesn't has that limitation

http://databases.aspfaq.com/database/what-are-the-limitations-of-msde.html