Not I, but very nice.

Thanks and great comments.

Barry, nice note and a good explanation. We are definitely looking more at kinds and attributes here, despite the BOL title.

Have you enabled the DAC? It's disabled by default. Use the Surface Area tool to turn it on.

Use an ORDER BY and a TOP 1, then add a HAVING clause to get only those ordered 1 time (if that's what you need.

I hadn't really planned on writing a lot about the differences between 2005 and 2008 as it seems 2008 is more of a 2005.5 to me, the core is very...

Sorry for the delay, I must be unsubscribed from this thread for some reason.

you can try here: http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx

no table, but it talks about 2005 clustering. Don't forget a lot of...

We do not condone posting of braindump links.

If you want to pass, study for the exam.

The balancing of memory among the instances depends on how much they're being used. As a guideline, you could divide memory equally and see how the instances perform and...

Were striped backups supported in v7?

I've never used devices for this. I'd use disk files only, not devices.

Why spend money? Pop a VM, install, restore, script, delete. No licensing issue. MS won't bang you for getting to the next version.

For DTS packages, you can try to upgrade,...

We'll have to agree to disagree on this one.

We can argue about whether an indexed view should be a type of index or not, but right now MS is choosing to call it that. Which means when you...

I'd dig through the error log looking for older entries.

I don't think you can restore 2000 msdb to 2005, structures are different, Agent different, etc.

What I might suggest is take...

This isn't clustered, is it? Saw a few notes about 64-bit cluster install issues.