Thanks again Gail. I think I will create the two indexes as you described. I have read several of your articles, and I do think I have a...

Okay Gail, I've read your series. It did provide me with a little better understanding of indexes than I had before, BUT, I'm now wondering, given the situation that...

Thanks Gail.

Okay, so what about a combined non-clustered index on LastName, FirstName, and DateOfBirth? Based upon the situation of having, or not having, the FirstName and/or the DateOfBirth, would...

Another method to strip the time from a date/time value and keep it as a datetime type would be: CONVERT(datetime,CONVERT(varchar,GetDate(),101))

I have a Buffalo Terastation Live (2TB) NAS server that I bought a couple of years ago (it was on sale for less than $800, quite a deal at the...

Darn it HansVE, you beat me to the punch! I was going to say exactly the same thing. I don't see why someone would go to all of...