I think a question a month isn't a bad thing. Let you learn a bit more in other areas.

I started and owned this site for 7 years before selling to Red Gate. We never bought or sold an address. As far as I know Red Gate has continue...

Add another database to log shipping, recover it, and run dbcc checkdb. You can log ship to any number of databases, and having a 2nd standby to run checks is...

Note that this doesn't usually matter to Microsoft. The important thing is that you are licensed for what you use.

Lots here: http://www.sqlservercentral.com/Scripts/Index+Management/

I was thinking massive rebuild of indexes as well.

Are they the same brand of SAN? You might have SAN-SAN replication.

If not, the best way to do this is move a full backup, then log backups until the time...

I didn't either. Started reading on this subject and my head began hurting. Keep Advil nearby.

Welcome back, ., and thanks for the advice and congrats. 🙂

I'd recommend you study with SQL Server 2008 right now. SQL Server 2005 has been out for almost 4 years, nearly half it's life cycle. While there will likely be...

I agree on the DVR. I rarely watch anything live, including sports. I'll start recording, watch a little, can pause and go off with life. Come back later.

I enjoyed Star...

The firewall is a Vista thing. Check the control panel, Firewall. Be sure that it allows SQL Server or 1433, 1434 through.

Cathy,

There's also a Forcibly Shrink the log script here [/url]on the site that will run a few transactions and shrink the log. It repeats this to clear out VLFs and...

I'd suggest you reformat the query as Bryan has, but use aliases for the tables. It will make it much easier to read.

Then if you can't get it, explain more...

Also, if there's something specific you are wondering about, let me know. I've written some updates from past summits, but I'm not sure I'm capturing the event. My blog here...