Partition by is like grouping...

My pleasure. Glad I could help.

Jeff Wikle (10/25/2007)

---

It appears, though, that my queries are getting more involved. Should I be looking to start creating Stored Procedures instead of having the whole query in my ASP?...

Now you know the power of a well-placed index. 😀 Glad I could help.

As for your date. Easiest way is to do a range query on the logdate. We can...

Makes sense.

Try moving the cluster to logdate (or if you do queries by date and time, to a logdate and logtime together). Is not ideal, but is better than...

With wildcards at the begnning of...

Full text does sound like the best option.

If you don't want to go full text, and your queries are always of the form

SELECT FROM ItemDetail WHERE ItemcodeDescription...

Cross post. Please continue discussions here

It appears you have a user in the db named sys. Sys is reserved in 2005, it's the system schema.

Try changing the user name to something else in SQL 2000,...

Did you shrink the data files, or just the log file? If the data files, you need to check the index fragmentation as the shrink probably shuffled the index...

Have you considered inplementing full-text indexing?

Could you possibly post the schema and the query so we can take a look?

Ok, there's a few issues at play here.

Your filter (LEN(desthost)>1) is forcing a table scan, as any function on a column prevents usage of indexes for that condition. (See this...

Offhand, I'm not sure you can upgrade that. The upgrade path from MCDBA SQL 2000 to ITP Admin is 2 exams (70-431, 70-447) while the non-upgrade route is three. (70-431,...

My instinct says the second should run faster, but there's only one way to really find out. Try them both out on a test server (wrapped in begin transaction ......

Wow. Is that...