Which is it? You've asked two things here. Are you changing the user name or the ownership of something.

Nope, but I'll add it to the list.

I was going to suggest what John wrote. Since locks are very transient, I'd use Profiler to capture SQL and when Tomcat hangs, go back at that time in the...

I'll see about the searching.

We're working on redirects now.

If you have more than the posts listed (but less than the next number), you get that title.

So 0-9 posts is Newbie, etc.

Add a subquery that gets the people that have passed.

So a

...

and studentid not in (select studentid from xx where score > 160)

Perhaps, need to check that.

Supreme Beings are removed, sorry 🙁

Thanks for the notes and please drop future suggestions in the "New Site " or Suggestions forums. I've passed these along.

I'd be very interested to see any benchmarking you do with this. I'd agree that the write cache is more important on the controller. Read cache is held in memory...

I'm guessing you mean Payroll app has R/W to the payroll db.

The admins can get in to the payroll db. No way around it. You could remove the admins from...

Thanks and we're working on the code fixes.

Steve

Your question is a bit convoluted and so I'm not quite sure what you want from the data.

Querying by week, you could use the datepart() function and use the week...

You can change the login name, but using the properties for that login.

Yep, getting notes here and there.

Please post in the Suggestions or New Site forums and we'll be patching stuff over the next few weeks.

Thanks for the notes and we'll work on correcting issues and responding to feedback. We've changed the notifications, so let us know if they're better now.