Are you really using SQL Server 7 or 2000?

I'd start with a simple query that returns the rows I want.

Select columns desired from table where age = 45 and posted_user_id...

I do something like Craig, except I halve the rows returned to find rows that cause the problem and then I identify the column(s) that are causing it. ...

Can you post the entire code block? The only error I can duplicate is the DirectCast error. Both CTYPE and Date.Parse are working in my tests.

Would a single index on Latitude and Longitude help? It seems that the optimizer is doing a great job of using the indexes available, and perhaps a composite index...

Excellent article Paul. A great primer to the concept of normalization with examples that I think anyone can understand. It's all well and good t tell people that...

WayneS (1/17/2011)

---

SQLRally: for those voting for the different presentations that can be presented at the SQLRally, my presentation on "Table Variables & Temporary Tables - What you NEED to know!"...

For those who are interested the results for the Professional Development track vote for SQLRally are in, http://bit.ly/eymEpp.

Voting is open for the Development track now, http://www.tinyurl.com/SQLRallyDevVote

We have at least...

Grant Fritchey (1/17/2011)

---

LutzM (1/16/2011)

---

Lynn Pettis (1/16/2011)

---

And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different...

I was monitoring the snowfall in New England with interest yesterday for a few reasons:

1. Originally from there so I'm always interested.

2. Relatives and friends there so I...

Grant Fritchey (1/12/2011)

---

WayneS (1/12/2011)

---

Grant Fritchey (1/12/2011)

---

Anyone interested in reading a short blog post? I'm a little nervous about putting this one up. I'm talking about how heaps are stored and...

I agree with Brandie, a entertaining and useful script.

We do the raffle tickets but this is better. Maybe add electronic sign-in to the meeting to generate the number for...

SQLkiwi (1/6/2011)

---

Jack Corbett (1/6/2011)

---

Not to insert a technical discussion here, but could you explain how NULLIF and COALESCE introduce subtle bugs. Perhaps start another thread and put the link...

I'm just glad the answer wasn't No Shirt at ALL!:-D

I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post which has a link to opt-in...

SQLkiwi (1/6/2011)

---

Hmmm. That's an interesting question. I don't like the idea of NULL being overworked...