Some years ago I took a sample of the standard MCDBA (or whatever it was called) test. I quit in disgust when it asked "How many tables can a SQL...

Hey PCD that's a cool tip, thanks. 🙂

Yup, a useful tip. As an aside, I'm bummed they discontinued rebuildm.exe. I only used it once, but it worked fine. Nobody mentioned, but (I believe since SQL 2005), you...

Thanks, Gethyn. 🙂

Well everybody, I'm pleased my comment about starting a db maintenance job with DBCC Checkdb inspired such discussion. Just to add some clarification... I have all of my sql agent...

Nice, Gethyn. But i like to run DBCC Checkdb as first step... If checkdb fails, the job quits and you don't end up backing up a corrupt database.

Hi Rudy & Everyone,

Nice solution Rudy. But just to throw an angle, I have resisted taking this approach for some time. I have my reasons:

I have about 30 servers/instances. A...

I've been using a job failure email notification method for some years now on SQL 2000 with the following differences:

1) I don't use a monitor server to check the other...

In solving performance problems, I always go look at the code in the query or stored proc. I haven't found one yet where the cause wasn't just a poorly written...

I've been using this one for quite some time. I like it because you can use it for combination keys (i.e. where the primary key is more than one column)....

I always just fetch into temp tables.

The proper tool for any job is that tool which was originally designed specifically for that job. For 2-tier client-server (which it sounds like you want), VB is NOT the...