Having a non clustered index on the date column WILL HELP with this query and it would probably be used due to the Where clause.

Oh dear. Where do you start with this one. Well let's try this: To create a primary key clustered index on the LAST_ORDER_DT column would require each value in the...

I think some people are missing the point with QOD. Even if you don't know the answer or get it wrong you then find out the right answer along with...

This has to be the most ridiculous QOD I've seen. The result you get depends on which database you run the query against and seeing as the database that the...

I'm sure this is a common and easy problem to run into. In my experience it wouldn't be as much of a problem if it wasn't for the fact that...

Is it possible that the model database has a different collation to that of the server instance. If it is then the tempdb collation will be rebuilt with the collation...

I would like to offer my thoughts based on lessons learned with past experiences.

In my work as a developer I also have to manage the design and distribution of a...

Steve. This article was of great interest to me as I recently had problems with being able to edit/delete jobs after renaming a server. It seems that in SQL 7...

This looks like it could be caused by the BackupDirectory registry entry. Or more accurately the lack of one! MSDE does not seem to set up a backup directory and...