We might just fit right in...

and

{click-whoosh}{click-whossh} I am the master now, Andy {click-whoosh}

Anyway, I finished running the simple tests. Here's a question given the following table & query, what might happen?

CREATE TABLE [dbo].[users](

[LogonID] [nvarchar](20) NOT...

Funny you should say that. I'm stepping through writing up samples in C# using nHibernate as I type this (well, right after I type this and right before). So far,...

Yep. You're in trouble now. I still haven't been able to get it fixed. A friend ripped out everything, including all references in the registry, and reinstalled 2005. He's running...

Oh, then it's not a covering index. Try adding the date column. It will be then.

I'm not sure if means anything in relation to LINQ and the other ORM products, but I've seen systems where the developers used ADO to automagically access the database. Small...

That's a pretty common PSS tactic. Until you're running the set of patches that they want to test against, they generally won't support you. Oh well, I've exhausted my feeble...

Hmmm, it's a covering index? Change the order of the columns then. You mentioned earlier that the statistics were up to date and the index wasn't fragmented, right?

You're getting a...

Stupid question, I realize, but being the stupid guy in the stack, it's my job.

What service pack are you currently running?

I just checked, squealservercentral.com is available. Steve?

Or maybe we should set up a parody site. We could use Brandy's pirate themes...

It sounds like you've covered everything from a DBA standpoint. It's starting to sound like some type of hardware issue, drivers, the OS, something along those lines. Sorry this hasn't...

I'd say no. The only thing you can do is eliminate the lookup by including or adding columns to the nonclustered index. Are you sure you can't do an include?...

Hmmm, no performance counters is an issue, although probably not a symptom of the performance problem. That makes it more difficult to know what's going on. Have you run Profiler?...

Bummer. Then you'll need to create a compound index, at least based on my tests. The query is basically OK (since you fixed the implicit data conversion, those things will...

Start here. Then try here. Then go here. You could also do a search of articles here at SQL Server Central.