I would suggest you try looking at the Resource Kits put out by Microsoft.  I used these and the Exam Cram books by Corolis to study for my MCDBA, but...

Hi Don,

I got most of my way through my MCDBA (SQL Server 7.0 & NT 4.0) before I landed a SQL Server DBA job.  It took lots of job applications...

Have you considered creating an application role and assigning users to it?

Cheers,

Angela

mdaniel,

As far as I know you cannot "repair" a .mdf file.  You will have to restore your database from backup.

In future make sure you have regular backups of your database.

Cheers,

Angela

Hi Mike,

SQL Server uses these stats to determine the best strategy for executing a query.  If the stats are out of date, SQL Server will use these stats even though...

Have a look at http://www.sqlcourse.com/

For basic syntax and online excercises.  There is also a more advanced course at http://www.sqlcourse2.com/

Cheers,

Angela

Hi Mike,

You should take a look at 'Statistical Information' in BOL (Books Online).  This may answer some of your questions.

With regard to having auto create statistics turned on, Microsoft recommends...

I had the same problem on one of our development machines with W2K, SQL Server 2000 and SQL SP 3 after rebuilding the RAID array.

Didn't end up finding an explanation...

Hi Chris,

Trace flag -T1807 should be documented in your Netapps doco.  It is AFAIK a undocumented, unsupported trace flag that can be set in SQL Server to allow it to...

Umm, not really sure what you mean, but if you are trying to identify which tables are what, ie, TableA is for transactional data and TableB is for customizations why...

I would turn Auto Stats OFF and have a job scheduled to run at a quiet time to update them.  If Auto stats is on it could be running while...

Nathan,

Sorry to be the bearer of bad news but all I can really suggest is start looking for another job unless you want to be constantly recovering suspect databases.

I worked...

Or you can use this function, which I did post in the Scripts section, but since the website upgrade, for one reason or another it no longer comes up in a...

Can you explain the "dead" threads you are seeing?  How do you know they are "dead".  Are you seeing SPIDs blocking other SPIDs?  Could your users possibly be inserting data...

Andrey,

I had this same discussion with a particular SAN vendor just last week.  From your post, I'm guessing you are trying to use these disk snapshots on a SAN.

In my...