Just as a note. The projected pace for SPs is one a year. There is supposed to be SP1 at 6 months post RTM (slightly late for 2008), but then...

Relations are logical structures based on RI constraints. If you have set those constraints, you can auto-build a diagram. If you haven't set them up, then there's no way for...

SQL Server just takes memory as it's needed for queries, caching, etc. On 64-bit, I would see it trying to cache everything it could, and perhaps running up to 10GB....

I'd agree with Jeff. This information doesn't make sense.

A database is a logical unit of data. While you might need to query across databases, you would never really use the...

What is a GSS address?

SQL Server just responds to requests. I'd think you'd configure GSS to request traffic to SQL Server, not the other way around.

Not to pick on your English, but if it's Sept 2009, then "it will expire" makes sense. Expired means the event happened in the past. I think that has confused...

We're still chasing down the create thread issue. I'll try to get more detail on the linked server item, though that might take a few days.

I do have some poorly...

Mirroring was 2005.

Replication might have been in 6.0 since the 6.0->6.5 upgrade was like 6 months.

Clustering was in NT 4 and v6.5. It did not work well, and was flaky....

We used to award points for articles in contests, but haven't done that in a few years. mainly because contests are a PIA.

We might add some other items in there....

There's a post in the Website Issues forum about what one developer found (http://www.sqlservercentral.com/Forums/Topic750454-433-1.aspx).

We moved the db for forums to a new server to alleviate some of the CPU and...

Eventually we'll sync them back up. I'll look to do a recalciulate of everything at some point.

The problem with log shipping is it leaves the database recovering. You can set this up to be readable, but when a new log comes in, everyone has to be...

Go with Tim's suggestion. Just run the log backups, don't shrink it.

And don't mess with the recovery model unless you know what you are doing. Certainly don't truncate it if...

It's never a good idea to back up to mapped drives across a network. A backup is NOT like a file copy. It does not retry, and has low tolerances...

dah dah dah dah dah dat's all folks!