It's true. Speaking as someone who is DBA, programmer, and sometimes end user, I do get to curse at myself a lot...

If you’re concerned about a web app, I wrote an ASP application that recorded info on all users of our corporate ASP pages, including IP addresses. It was pretty...

I guess this QOD was closer to reality, where the simple problem gets buried under everything else. I did happen to see right through to the answer, but I...

Methinks columns and pages r holey different animals. Someone correct me if I'm wrong - pages are the units in which data is physically stored on the disk. ...

Those who got the question wrong probably also haven't been peeking in Query Analyzer or working with SQL Server much either.

Actually it's good to vary the QOD...

I thought the only ridiculous part of the question is that it was damn easy.

The QOD would be a problem if it weren't for the rollback, because the au_id...

Oh... I thought it might be like Jeopardy, where we have to guess the question.

Should be an option: "I don't have a @#*&% clue about this, but I like points. So just mark it right for me tomorrow"

I had a feeling that would be the answer - but with all the other wonderful things out there, maybe there would be a way to do it.

Nowadays I suppose...

The MS sites can be confusing at first - a clear explanation of certifications would be helpful.

The main exams for "SQL server 2000 Database Administration Track Certification" (MCDBA) are:

70-228 DB...

I've had problems where page breaks were inserted, screwing up the code.

I have no idea if this is your problem, but it's something to look for.

You can keep the apps in separate dbs, with their own specific tables, views, procs, et al. Meanwhile any common data tables are accessed from one main DB.

That's what...

I still have the question: is it possible restore a db from backup where the db would only fit on the drive once it's shrunk?

The DBs were huge mostly due to the log files. They were probably never shrunk & bulk-log recovery model leads to large log files when bulk operations are performed.

I...

True - it should read: everyone EXCEPT the issuer of the command. On the other point I think bhaberman is wrong: existing connections will be broken & transactions...