Consistency != inflexibility

If you want to try something new, then you develop a consistent way to do it, propose it to the group, explain it, debate it, etc. and make...

The page split thing is an interesting one and it makes sense. You're allowing read of dirty data and page splits, and re indexing, would have uncommitted transactions in terms...

Very strange. I'm not sure what happened here. I know the maintenance plan opens a cursor in some tasks to loop through databases, but I'm not sure why you'd get...

The log file is set to a certain size, not grown from 0. A restore restores the data, not the log. It sets the log file size, but it doesn't...

I'm confused a little. Who has what date setting?

Your PC

Your SQL instance

Server SQL Instance

Server date settings

client workstation settings

This can get tricky as some date settings are handled by the client...

What did you pass along?

What doesn't always work?

Set up a unique index if this is really important.

Agree with Sergiy. The error tells you the problem.

The other thing is this allows for scalability. If one client grows a lot, or becomes a query resource hog, you can easily move them to their own server.

This runs a query as a READUNCOMMITTED isolation level (http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/2007week16.aspx).

It allows you to read changed data as it doesn't set up locks on the tables, essentially dirty reads. Not necessarily...

You should read and understand what the log is doing. It protects your database and ensures integrity.

If this is production data, you should be running with full recovery mode and...

I see a note here about a post SP2 fix: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1481112&SiteID=17

https://forums.microsoft.com/technet/showpost.aspx?postid=1565323&siteid=17&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

It's a good point and we try to link back, though sometimes articles come with some time between them and many part series, so it's hard to link them all...

I'm always amazed how many people are weeded out from a simple test/quiz beforehand. At one point I made sure that I only interviewed people that got 75% or better...

SQL2K5 doesn't have compressed backups without a third party tool. SQL 2008 will have them in Enterprise Edition.