Full backups don't truncate the log and hence don't break the log chain. In your example, it's possible to take the previous day's full backup and restore all the logs...

You can, but you'll have to check every single input box and every query string. It's probably better to look at the code of the app and see how it's...

The problem with this is that the repeated (Column = Variable or variable = constant) expressions confuse the optimiser's estimations of rows affected (on 2005 definitly, not sure about 2008)

It's...

Table variables are always added to the TempDB system tables and are allocated space within TempDB. They won't actually be written to disk unless there's memory pressure, but the framework...

You should disable it completely, if you can. If not, then a workaround is...

How about books online:

Optimizing Server Performance Using Memory Configuration Options

---

Do not set...

This may be useful:

http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx

It's not. SQL 2005 handles it better than SQL 2000 did, but still... Can lead to random,...

Get a bigger drive.

If you're putting data into the database it is going to grow. You can look at archiving or deleting data that's no longer necessary, but that's...

Is you coworker asking for separate servers or separate virtual servers?

Don't shrink your database at all. It causes very bad index fragmentation and the DB will just grow again next time some data is added or those fragmented indexes are...

You can. If you haven't made changes to the model database, it's not necessary.

I don't. It was mentioned in a presentation. I'll see if I can find a ref for you.

Keyword filters aren't a very good way of defending against SQL injection.

1) Use only procedures (preferably) or parameterised queries from your front end apps.

2) Ensure that the app user has...

What was the error when the service didn't start? There would have been something in the SQL error log.

Install

Patch

Ensure that the user DB files are in the same location as...