master should never be put in anything other than SIMPLE recovery mode.  I thought SQL always put master into SIMPLE mode whenever it started, but I may be wrong.  There...

If the user's Windows login and a SQL Server login are identical, and the user has rights to login to SQL Server via their Windows account, then you will get...

My understanding is that by default Citrix will use a MS-Access database to hold its critical information.  You have an option to use SQL Server in place of Access.

You need...

As other people have pointed out, the easiest way to move a table to another filegroup is to re-create the cluster index with

CREATE CLUSTERED INDEX ... WITH DROP_EXISTING ON filegroupname

This...

My experience is that tempdb goes through some re-initialisation process rather than being totally re-written.  We have a tempdb of 50 GB on a DW system and SQL has no...

Never shrink any database file if you expect it to grow to its original size within 3 months, except for an emergency.  All you are doing is causing Windows NTFS...

Definitely check that tempdb has enough space to grow.

If you are sure that tempdb can get all the space it needs, then I would report this problem to Microsoft.

You need to work out how much space is needed for tempdb, then set the initial size of tempdb mdf and log to match your business needs.  It is also...

As previous people have said, it is possible to run a mixture of MSDE and full SQL instances on the same machine.

Because of likely memory and CPU pressure, you should...

I think the trick with sp_ is in BOL somewhere, or Google will know where to find it...

If a sp starts 'SP_', SQL assumes it lives in master, regardless of...

First, about statistics.... 

The optimiser chooses how to run the query depending on the values held in the statistics.  If your statistics are so old they no longer accurately describe...

You can run into problems if you run CHECKDB in a maintenance plan against a database that requires ARITHABORT ON.  The job step is always generated without a SET ARITHABORT ON...

Something I found in SP2...  You can ALTER a database to use the new vardecimal format, except that you cannot ALTER any of the system databases to accept vardecimal.

It does...

As Andrew says, an empty string is not NULL in SQL Server, as per the ANSI SQL standard.  In Oracle, an empty string is NULL, but Oracle is outside the...

If the log file fills up you need to increase the size of the log file.  If the data file fills up you need to increase the size of the...