If you access your table via a stored procedure, the access plan will be created the first time the SP is run after SQL startup.

It is possible that...

The system databases are created on the disk where you put the SQL program folders.

Best practice is to leave master, mssqlsystemresource and model where they are installed.

You should...

Every database needs some free space. As a minimum, you will need enough free space to hold a copy of your largest table plus its indexes, so that you...

SQL Server FineBuild has scripts that help you export and import jobs. Feel free to raid the code for whatever you want.

There is a problem area moving jobs that...

Steve is tright. you absolutely MUST run DBCC CHECKDB, and make sure you use the ALL_ERRORMSGS option and do NOT use the REPAIR_ALLOW_DATA_LOSS.

Sometimes Windows may report errors with SQL...

It is generally considered to be bad practice to log on to a production SQL Server box in order to do management tasks.

The use of Windows desktop takes...

If you aer a sysadmin and you run xp_cmdshell, it will run using the credentials of the SQL Server service account.

If SQL is run using LOCAL SYSTEM authority,...

You really need to do some workload simulation, so you have ral figures for your installation.

Your tests will show how many I-O streams can be supported by your disk subsystem....

The advice about puting each filegroup on its own RAID set has a good intention at its heart, but is not really correct.

SQL Server can initiate multiple I-O streams against...

I was thinking of SQL Server table partitioning, not Windows drive partitions...

There is nothing to stop you putting all your file groups on a single drive. However, you should...

IMHO do not worry about separating partitions to different disks. Using partitions has a very significant advantage over using a status column in the clustered index...

The partitioning...

My understanding is that the 'Administrator' in question is a member of the Windows local Administrators group, not a SQL Sysadmin. This means the list of people who could...

This thread shows the problems that can happen when you want to do something that is totally unnecessary.

There are no performance or data integrity advantages to moving model database. ...

If you are going to finance learning SQL Server yourself, ten I recomend you get a Technet subscription. This cosst about GBP 250 in year 1, with a GBP...

A bit off-topic, but I am interested in knowing what benefits you see in C2 logging, and who in your organisation is requesting that you do this.

The DOD TCSEC standard...