SQL Server can actually use multiple asynchronous I/O requests against a single file too.  Now there may be some performance benefit in splitting the files across multiple I/O channels or...

Yes you can run multiple CREATE INDEX statements "at the same time" on Standard Edition, however the mention of parallel index creation refers to a single CREATE statement being able...

From BOL "CREATE INDEX"

"On multiprocessor computers on SQL Server Enterprise and Developer Editions, CREATE INDEX automatically uses more processors to perform the scan and sort, in the same way as...

This feature refers to the ability of SQL Server to employ more than one processor in the creation of an index, rather than referring to the number of indexes that...

I missed the bit about them being in the Primary group.  Sorry.  About the only thing you can do at this point is to create another database with the files/file...

Use the DBCC SHRINKFILE ('filename', EMPTYFILE) command to remove all data from the file and then use the ALTER DATABASE command to remove the file.

You will need to edit the registry.  HKEY_Local_Machine\SOFTWARE\Microsoft\MSSQLServer\Parameters

Change the SQLArg0 to reflect the new path and file name of the master data file.

Change the SQLArg1 to reflect the new path...

If you are getting a red x for the second step, the step was attempted and errrored out.  Did you get any kind of error message when you double click...

If you are talking about SQL Server 2000 the CAL's are not sold on the basis of concurrent users.  They are for either named users or named devices, so you need...

You might get some improvement if you bump up your network packet size.  This will probably only net a pretty incremental gain on large data transfers, but it could also hurt smaller...

I'm afraid the only place to get that information is from the views themselves.  The sysdepends and the INFOMATION_SCHEMA views are limited to a single database's objects.

I'm not sure what you mean by Linked Steps.  You do need to redo any workflow definitions that were in place before you rename the steps, but I've not had...

Unfortunately the DTS packages, including all the steps are contained in a binary image in sysdtspackages so there is no way of easily retrieving the step descriptions.  However, you can change the step...

That sounds very strange, the only thing I can think of that might cause that is the job definition.  Open up the job that runs the transaction log backups and...

By file format I assume you are asking about the file naming convention.  By convention, database backup files are named using the ".bak" extension and transaction log backups use ".trn",...