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...

As Noel mentioned, you need to just change the name. The restore dialog in SSMS lets you just type a new name in there at the top.

The second option gets more confusing for data manipulation. I like it better, but you have to understand the 21 values in the registration form will be rows in a...

The vendor forums are under the products and books Forum. I'm in process of moving some stuff off the main page to lower the pressure on that page. I'll add...

This should be changed. One of the items I changed while I was poking around. It used to require some text input and not just a smiley.

There's too manY!

Just for the forum tweaks (not site or email or anything), this instant forum must have 50-60 items to go through. Each group, permissions wise, has over 100,...

Have you actually checked with Veritas? Not sure what these are used for, but they might provide you with some answers. I doubt there's a whitepaper, but you never know.

LOL, not many people have more than 500, but it's definitely something to work on. Probably a better search would help here.

The default in the new forums, which we bought, didn't write, is to not subscribe you.

We are changing that for a release tomorrow so you'll be subscribed by default. If...