Viewing 9 posts - 1 through 9 (of 9 total)
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.
November 21, 2003 at 6:08 am
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...
November 21, 2003 at 3:22 am
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...
October 16, 2003 at 5:46 am
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...
September 29, 2003 at 2:53 am
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...
March 25, 2003 at 3:50 am
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...
March 20, 2003 at 3:40 am
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...
March 1, 2003 at 9:40 am
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...
September 16, 2002 at 3:01 am
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...
December 12, 2001 at 3:10 pm
Viewing 9 posts - 1 through 9 (of 9 total)