In general I just keep a timewindow open for automatic update.  But  I once used a batch file that started on windows startup.  It used head to read the first line...

First,  it is better to post this kind of questions in the performance forum.

There are lots of possibilities.  The most obvious is "do regular update statistics", automatic or throught a...

I don't know foxpro, but are you looking for this t-SQL function?

ISNULL ( check_expression , replacement_value )

My guess would be that the last but one log backup takes too long.

There is a posibility to get more information from the maintenance plan.

Let the job that does the...

I wrote the following for internal use.  It just puts all the date format material from the books online together.

Joachim.

MS SQL Server (Using Convert)

Date...

I thought "Enable report execution logging" in the site settings meant logging in the database, but I might be mistaken.

If you are talking about the logs in "C:\Program Files\Microsoft SQL...

For the reports, datasources etc. you need to backup the ReportServer database. 

Backing up applications under windows is complicated.  Use a ghost image or restore Reporting Services again.

When I have a hard coded date,  I use convert  with the appropiate datestyle to convert the string to a date.  That makes it independent of the environment.

(It seems my previous reply did not arrive.)

No, you wil need hints.

It is possible let a certain table always use table locks, but not to let it always use rowlocks

You can use the "with (rowlock)" hint in your statements.

The traceflag 1211 (DBCC traceon(1211)) prevents all lock escalation on the whole server.

Joachim. 

If I understand you correctly,  the user dbo in the database is bound to the login jim .  In that case you have to look at permissions for user dbo.

Joachim.

I also have a Windows 2000 server with .Net 1.1 recently installed, but that had no effects on SQL Server.  There are no strange login attempts.  As far as I know .Net...

In theory the limiting factor could be output to screen, although I never saw the CPU go to 0 because of that.  Minimizing isqlw could make a difference.

I tried it on my...

I never found a way.

As a work around I let awk  (gawk actually) check the output file for the regular expression /Msg/||/[Ee]rror/ and exit awk with an error code if...

I agree with Anil, but the it is better to put the pagefile with the SQLServer program files or OS than with database files.  The OS programs and sqlserver program...