The default for -g in SQL Server 2000 is 256 MB (See Using Startup Options in BOL). What I did was increase this by 64 MB until the system...

I had this on a SQL 2000 box some years back. The ultimate fix for my problem was to add a -g startup parameter to leave more memory unallocated...

BOL asys you can move master and mssqlsystemresource. SP2 assumes it is in the default location and will leave you with an unstartable SQL Server if they have been...

The Microsoft JDBC driver is called sqljdbc_xa.dll, so your problem is most likely to be with any JDBC driver supplied with Websphere.

The most likely problem is that your sqljdbc.dll file...

Oh dear, another question where the Microsoft documentation triumphs over reality.

I have added some community content to http://msdn.microsoft.com/en-us/library/ms175049.aspx. If anyone wishes to add to it please do.

Deep Thought.

Marvin and Holly are very close contenders, but Deep Thought has the solution to Life, the Universe, and Everything, even though you won't like the answer.

Some time ago on SQL Server 2000 SP4, I noticed a problem with view that contains a UNION:

a) You have a view with a number of UNION ALL statements

b) You...

The two words do get used for either purpose.

It is correct to say that recover is the process of getting your database working again, and restore is a technique you...

If you are talking about software versions, do not forget about the Windows patch level, the AV control file level, etc, etc ad almost infinitum. Then we get into...

Try specifying multiple output files for the backup. This should allow parallelism of the database read so that all files are filled at the same time.

I once had a...

If Misrosoft offer hosting to comercial companies, I suspect they will discover some of the realities of the commercial world. Having worked for a hosting provider that also offered...

This really does need to be controlled by your Windows Admin people using a GPO. There are Windows rights for 'Sutdown a server' and 'Remote shutdown a server' that...

The figure of 8 tempdb files was not linked to and given value of MAXDOP. It was presented as the results of testing on large servers (32 and 64...

You need to start with your design requirements. It is not possible to say that storing multimedia in SQL Server is always a good idea or always a bad...

If you do some performance tests comparing table variables with #temp tables, be aware that relative performance can change depending on the volume of data involved.

I have seen examples where...