what is the compabilitymode of the database in sql 2005?

one sure way is to pass all datetimes in universal format

yyyymmdd hhnnss (yearsmonthsdays hoursminutessecondes)

instead of relying on SET DATEFORMAT that might change between language settings.

Where did you add the max transfersize? (is this replication?)

I can't find it in the BOL

BACKUP LOG { database_name | @database_name_var }

{

TO ...

I'm using sql agent too as backupper and restorer.

Prod server: sql agent daily backup database to networklocation...

Standby server: sql agent daily restore backup. If any error comes up the backup...

the ones i use mostly

are

sp_who2: to find out current connections and who's blocking who.

and

DBCC INPUTBUFFER (SPID)

There could also be an error with the replication agents.

Depending on the requirements

you could split the statisticsupdate over 2 days.

Using a cursors to loop through the objects and applying

UPDATE STATISTICS.

You could also reduce the sample size.

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.