Ed,

We are talking about having a few other "badges" that we can apply to someone's account. For now I'd say they could add it (with a link to their profile...

Backup/restore is the simplest way to do this.

The import export is an SSIS package, which essentially scripts out the schemas, runs those on the new server, and then copies data....

My favorite is "assuming programmers will build what I ask them to"

Falls down almost every single time.

Great job, Phil!

I'm not sure Jeff will get that one done, so someone else feel free to tackle it. He's agreed to start a nice T-SQL book for us all, so I'm...

Short answer, run backup log with truncate_only option, then shrink the log file.

You need to either set simple recovery model for that database (in the options) or set up log...

Nope, the log and data files are overwritten in a restore. Apex Log won't help you.

The typical "copy" process on SQL Server is a backup and restore, so I'd recommend that.

GilaMonster (4/7/2009)

---

Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' for the project manager, the token...

You'd have to test, but I don't believe the replication moves indexing across. Mirroring would, since it reads the logs and sends the transaction across. I believe replication only moves...

That's a good idea as well. It gives you posts. Not sure there's a way to do the overall score.

If you're 11, does it matter where 6-10 are? You won't...

Not a bad idea. We used to have some tests, but they're complicated and hard to set up.

I'll revisit this and see if it makes sense.

I think T-SQL is relatively easy to read as well, once it's formatted the way I see it.

At least as easy to read as some of the C++ I've seen,

The MVP certainly isn't a ton of knowledge. It's a community contribution award.

Arguably I haven't contributed anything substantial to the SQL knowledge base in quite some time. Instead I think...

The master database controls the function of the server. It is not designed to emulate a SQL 2000 server, and all the structures in there will not necessarily work. It's...

I think you're always trying to reduce risk. Even if you want to tackle a new venture, or make a new risk in an area, you want to reduce the...