Okay, I finally finished my daily server audits and I've got some time to work on this.

Below is my test code. I alternately commented out or un-commented lines to...

Jeff,

I'll post my test code when I get back to work tomorrow morning.

In the meantime, may I suggest a hot toddy: A small glass, a little lemon juice, some...

Lynn,

I just tested Jeff's starter kit code, too. It ran in 3 seconds.

I did some testing of SELECT statements, with and without a non-clustered index on the UniqueVarChar column....

Thanks for sharing the CHECKSUM links. I didn't know that function existed.

That's a pretty cool way of quickly narrowing searches on large chucks of character data.

LC

Jeff, J-F, Ian, Matt,

I sincerely apologize. I'm not liable for anything I think, say, or do until after my 3rd cup of coffee in the morning. When I read Jeff's...

Thanks Grant and Ten. I'll simply move forward on indexing.

Old Hand: Note that without a WHERE clause, a CROSS JOIN produces a cartesian product. If you don't believe me, look...

Jeff,

Before I use your suggestion to produce a 1M times 1M cartesian product that will consume all of memory, my CPU, and a hard drive, I'd appreciate an explanation of...

Thanks for your responses.

Sincerely,

LC

Thanks for your responses. I should have been more specific in my first post.

I've got a situation where I have a concatenated index consisting of 3 columns in a non-clustered...

Thanks to all of you for your replies.

LC

Marvin,

What do you monitor on the tempdb?

What problems might there be and what indicators would alert you?

LC

Grant,

I don't think so. I'm running DTA as a server and dba admin with authority to do anything so I don't think that's it but thanks for asking about it....

Grant Fritchey (9/4/2009)

---

Are you running the DTA against the production server? I hope not. If you're running it against another machine, you may need to validate that it has all...

I was once new to DBA work and I remember what that was like, so I'll give you some places to start.

First, your job is to create a condition...

That should do it.

Thanks,

LC