Matt, Great catch. I missed that in the thread.

There's no good way to do this for a like in 2005. 2008 is supposed to include encrypted indexes, but I'm not...

I could go three! I'll throw in some books as well 🙂

At the very least, can you post a picture to this SQLBay auction??

It's actually not AJAX. It always loads, just closed off by default. It's some type of DIV tag.

If you open it, a cookie will open it next time.

I only fixed that one. I'll have to search around for others.

you can recycle an application pool in IIS based on worker threads, memory use, time of day, and some other options. We used to recycle a few times a day...

If you have enterprise edition, it's included. There's a wizard and menu item.

If you don't, it's simple. Backup logs, copy them to the destination server, restore them with NORECOVERY.

If you...

I've had great luck with batching updates into smaller chunks. One long update might take an hour, but going with quarters (1/4) each time, I might get all 4 to...

First, what version of server and how are you trying to connect? Also what error message?

Second, please post in the appropriate forum. Read the titles of each page to know...

Previous versions allowed pinning, but current versions do not.

I think Jeff has the best idea.

You might get an upgrade, but I doubt they'd give you much credit. If you want to try, I'd contact Microsoft.

But be ready to pitch it.

If you decide to pitch...

I'll report this and we'll see. There was a recycle set on memory, but it's been removed.

The first post is there for you to describe the poll. This won't change as it's a fundamental piece of the forums.

A bug with the service putting out the ads. It should be corrected.

We are rearranging things on this page to relieve some of the pressure.

This is fixed.