I'm not the SQL guy for my place of employment and said person is out of the office and unavailable for the next few weeks. Even then he is more of an oracle guy and NOT a sql admin (sql server is ...

Transaction logs are a vital yet often overlooked component of database architecture. They are often forgotten because they are not something actively maintained like the schema contained within a ...

I wanted to get some suggestions for scheduled maintenace on a SQL Server 2000 box that is hosting a relatively small database (<=13GB). I already have a weekly integrity check that reorganizes data ...