Thanks for the confirmation William. You have confirmed what I had thought. Just got this new Visa laptop to begin familiarization and testing for our site. What a different 'computing...

Just an FYI ... I tried to install SQL 2K Std on Vista and was only allowed the client components ... and boy did it complain but it works ...

Another good source to augment your knowledge would be white papers and case studies from SAN vendors. I use the plural form of vendors specifically. Do not just use your...

I have read many interesting points and experiences thusfar and cannnot add anything that has not already been said. So we will get right to the point.

• Major release - every...

The link to Schneier's article is quite interesting. Like the editorial and posts they are very thought provoking. However I tend to want to take this back to a simpler...

I would definitelt NOT use append mode for backup files. The potential for data loss exists. Granted it is rare that an appended backup file goes bad. But, it will...

#1 on the Top Ten list of answers you do not want to hear from your DBA - "Well, it depends " ...

You may or may not get any...

How many databases are there on the SQL Server ?

Now if you have hundreds to thousands of databases then there is a system SP that can be modified to speed...

I feel that option 'e' - none of the above is also not optimal.

I'd opt for option 'f' - management and user education followed by an additional budget request for...

Thanks Jeff ... a few other questions for when you get the DDL as well.

• How many rows are in the table ?
• How many pages/extents does it occupy ?
• What type of application uses...

Execute rebuildm.exe first then sqlservr.exe -c -m. Once the bare bones instance is up you should be able to perform your restore of the master database from ISQL or ISQLw.

It sounds as if Anders is going to 'burn' something for the mail ... good show ...

I'd be curious to see the DDL for the table and its associated object(s) ...

Since this is SQL there is always another way to do something.

select name

from sysobjects

where objectproperty(id,'TableHasNonclustIndex') = 1

Well, I would try using 1204, 1222 and 3605 as startup parameters.

Also here's an MSDN link for reference. http://msdn2.microsoft.com/en-us/library/ms178104.aspx

Out of curiosity what are the results of SELECT @@VERSION on...