Brandie,

I'm slightly buried, but I'll try to get you one in the next week. Got to finish a presentation first 🙁

I think this is a good reason why we should have "certified" applications for SQL Server. Some way to limit access to the server to both a user and an...

Performance could be drastically different, though. Keep that in mind and set expectations from users. Especially if you have > 4GB of RAM.

If you are using SQLMail, I'd start to move off it. It is deprecated in 2005, meaning it will be removed in future versions. Also, it doesn't work on 64-bit...

The NO_LOG and TRUNCATE_ONLY options break the backup chain. IF you run these, you need to do a full backup right away.

However, a log backup removes the inactive transactions, or...

Filestream is only in 2008.

I think Agile works great in the DB, it's just different clients. Communicate often and regularly with the developers, who are your clients. Address their needs and change direction when...

The danger is knowledge.

MySQL is used by Yahoo and some other huge clients. Sun now supports it and it runs great in all sizes of companies. It has a modular...

You can implement your own version of log shipping without the overhead from SQL.

Run a backup, move that, while it's moving, run a diff, move that, then while things are...

It should be using SSIS, which I think has a few issues between 32 and 64 bit. However if you run it from the source, or from your workstation, I'm...

What's first? You need an order to determine that.

You can select top 1 ... order by xxx as a subselect and then use that as the update.

for multiple rows it...

I'd second the vote for Inside SQL Server - Query Tuning.

Colin,

If you want to post it here, we'd love to publish it on the site.

What is the execution plan and what are the types/indexes on?

Need more information.

There's always work being done and I'm sure we'll see more enhancements to SQL to handle common tasks as it evolves.

I think SQL works great, but there are always things...

Jack has the best idea. Any network hiccup will cause the backup to fail. Run it to the local server and then copy it to your hard drive.