Ha ha!

Sample dialogue using the 'B' answer:

BOSS: I see you are querying an offline cube in Analysis Services. Can I access your cube as well to perform some analysis?

DBA:...

That's a good point about Apple. They certainly have that reputation, and it has been furthered by a jealously loyal user base.

How much of that reputation is based on a...

Since the query returns the number and the names (if you run it in Query Analyzer the number shows up for you in the status bar anyway), I didn't see...

My completely anecdotally based guess is that it will be at least a generation (20-30 years) before anything like real 100% automation exists for an entire company's IT infrastructure -...

I agree. I was tempted to pick A, but (and perhaps I was reading the question too literally) picked D because the question said the cost had to be below...

In principle there is no difference, but in PR terms there may be. People may have the wrong impression that a system is automatically more secure when it uses a...

Thanks! I think it turned out that the performance issue in this case was not due to the database, which supports your suggestion that the tlog size was not the...

Just an update - the transaction log file size is now up to about 2 GB.

Is this OK?

Thanks again.

----

webrunner

We are on SP1. SP2 had some trouble so we have not moved to it yet.

I ended up writing a T-SQL procedure to do the deletions, based on an example...

I know the feeling. Looking forward to getting the script if you can post it.

Thanks again!

---

webrunner

Thanks, that is good to know. So a database that is, say, 610 MB, with a tlog file that is 615 MB, is not necessarily bad?

In terms of performance,...

Hi, and thanks,

The reason I think it is too large is that it is larger than the database file itself (the .mdf file). I thought that was a sign of...

Thanks for your reply. I'll try to answer your questions as best I can.

We run transaction log backups every hour. We make a full backup once per dayat 6:00 pm....

Thanks to everyone for the advice.

rstone - would you be willing to share the details of the job you created that runs every 15 sconds and logs/emails info? At least...

Thanks to everyone for the replies. Modifying the owner worked. I made a copy of the job and set the owner to the generic account the previous DBA created for...