I tend to agree with Jack that any database could work. However I'll qualify in terms of what scale/rate you're looking at. If you were to want to store high...

If I buy a painting, I don't have a license. I have the right to do what I wish with it, including destroy it. I can copy it if I...

I'm confused. You installed SQL express on your machine and how do you register other servers? I thought Management Studio didn't come with express.

In any case, Management Studio shouldn't be...

You are really doing parsing at this point, which isn't a strong point of T-SQL.

You can use charindex/patindex in the returned field (Cast to varchar) and then find the...

The DBMK will be encrypted with the SMK, but you can unencrypt it and back it up, then open it on the new server, or after the restore and encrypt...

Couple questions, are you inserting scalar, specific data? Is there a PK on the fields?

If there's a primary key, and there should be, then it won't insert. You could move...

Mirroring is at the database level, so you'd need the Database Master Key, not the Service Master.

It's cut off in the searches, and I agree. It's annoying. It is in the title of the browser if you open it and it's also in the forum view...

Search is so-so, but it's there for you to find things. We use Google search, so their hints will work here.

The "Active Threads" on the left menu shows you threads...

I agree with Gail and I might break these out to a few separate traces (object changes v access) to deal with the data.

Be sure you have a good...

Are you upgrading to SQL 2005? There is an upgrade advisor you can run to help with this.

The database size is large, TBs of data, so I'm not sure that's...

Please don't cross post. This is being answered here: http://www.sqlservercentral.com/Forums/Topic433813-338-1.aspx

This should help

http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

Very interesting, and I have ideas, but they're probably ones you've thought of and since I don't have any direct experience with something this scale in 2005, I hope someone...

Yes, use the ATTACH_REBUILD_LOG option (look it up to be sure I'm write) with the attach command.