BTW, someone pinged me about a GTR posting bad info and causing trouble. Anyone have complaints, or are these other teaching moments?

That should work. You are looking as long as deletes occur. If you happen to delete the last 1000 rows and rowcout = 1000, you look again, even if there...

That discussion could turn out to be a great teaching moment. It's a good debate, and the chance to both help the OP as well as see if you can...

The two local centers I've used in Denver give me 2-3 sheets of blank paper and a pencil. After the exam I have to turn the paper and pencil back...

There verify typically isn't much time added. Not sure how much, but you could easily test this on your system.

In terms of logs, I'm with Gail. Each log file to...

multiple databases, single instance. I was responding to your initial question, and didn't make it clear.

In general, the balancing of memory between instances, and potentially CPU, isn't worth it to...

To add

If tempdb could be an issue because both use it heavily, multiple instances can make sense.

I prefer multiple databases for applications if possible. That's what SQL Server was designed...

This is great!

It's easy if you control all the tables. What if you're being asked for a report from something like JD Edwards OneWorld, which is a large ERP package. The tables...

Good points. I sometimes get caught up in the "no more government" frenzy at times. Regulations do...

As mentioned, you can't go backwards. It's not the 32 v 64, it's the versions of the software. The compatibility level of the database doesn't matter.

The way you do this...

Not a tax, a requirement to meet some standard. There's a difference.

Just wanted to be sure. Indifference doesn't help any more than panic.

It's good to train your manager, or a manager, to try and get them to remember that they need...

I'm not necessarily proposing this, but before you get too upset keep a few things in mind.

We have lots of requirements for interconnections. We require cars to be < xx...

I don't know that I'd wash my hands of something that was ongoing. I've seen sysadmins try to do something because I was slower to respond, like the time I...