I got that right away, hmmm, what does that say about me?

My kids wanted to listen to the Titantic...

The question has been corrected and the points awarded back.

Nice job, Robert.

You should provide the plan, as Barry suggested. The idea is that you look in the plan for what takes a lot of time. Then try to reduce the time....

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.