Microsoft SQL Server Administration

SQL Server 2000 cluster While trying to move the master, model, etc db's I put trace flags into the startup according to the instruction in: [link] When that didn't work, I tried splitting the 3 args into 3 seperate options. ...

Or stage environment has "only" 2gb memory while the production has 8gb. We have a couple of large tables in the DB that is around 1-2gb large. We are noticing that when you make queries against these big tables we ...

I am experiencing the dreaded "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed." error.  It is on Sql 2000 / Windows 2003.  It, of course, started to happen out of the blue.  This happens when I run a ...

I'm looking at a new, freshly configured clustered server ('a' node) and examining the partitions with DISKPART. I don't understand what I'm seeing, nor do I know if it is best. First (from chkdsk) all volumes have a 4 KB AUs (blocks) and I believe that ...