Are you sure that SQL Server accepts Mixed mode connections? Just double check and be sure your IPs are correct. I've had people change them and someone else doesn't realize...

Here's a few options:

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

http://msdn2.microsoft.com/en-us/library/ms159272.aspx

It's on the list, but it's a lower priority.

Search now limits by forum, but still won't help with what you are looking for.

Chris,

Do you mean a new reply? I agree that the front page doesn't do a great job , but I'm not sure the old one showed replies at the top...

Jason,

I think you have a good plan for now. Look at them on disk as well (defrag there) and then go with your plan.

Filters Added today!

We'll work on search over time and see what we can come up with.

Steve

:), note the access rights and then remove them. It's the easiest way to see if someone's using the table.

Or you can set up a trace for access to certain...

Don't set a lot of alerts. Let them track things and have some metrics ready on what you track. Too many things spike for minutes, like CPU, to alert on....

Shrinking could help, but you need to then be sure that you rebuild the indexes. You've mentioned it, but it's important to clear fragmentation for your heavily used queries. So...

A couple thoughts on this.

First, if you can eliminate functions, you can really speed things up. Since you're looking for stuff compare to today, you might be better off calculating...

I'm not sure you can avoid it for that query, but you can inject intelligence into your application. If you have exact searches, then use a query (or proc) that...

Thanks! I knew we were getting close, but I lost track of this in all the bugs!

This is such and open ended question. If you can't narrow down what is slow, it's hard for us to help you.

First, define slow. How do you know it's slow....

Charles,

That's great and it's a wonderful example of thinking outside the box and looking for reuse. Probably beats buying anything else or tracking bugs in Excel.

Not sure I can do anything about the perfume. It tends to permeate the air with six horses nearby 🙁

Thanks for the suggestions and I'll keep investigating options. If I...