wbrianwhite (7/21/2010)

---

Since you were using lat/long datatypes - did you look into the geometry data type?

http://msdn.microsoft.com/en-us/library/bb964711.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/c557032a-038e-480c-84e8-7f0ad72e1af7

I've read about it a little, but haven't used it yet....

Since you were using lat/long datatypes - did you look into the geometry data type?

http://msdn.microsoft.com/en-us/library/bb964711.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlspatial/thread/c557032a-038e-480c-84e8-7f0ad72e1af7

I've read about it a little, but haven't used it yet. ...

I had always heard that you should do a "select count(1) from table".

http://www.techonthenet.com/sql/count.php

"TIP: Performance Tuning

Since the COUNT function will return the same results regardless of what NOT NULL...

Look at the execution plan, look at and think about what you are typing. Having complex queries will benefit from compiling and recompiling a stored procedure. This is because having...

R. C. van Dijk (8/24/2009)Having 100 rows of data is in about 80% (or more) of the times to much info. Users are interested in data they can use. Overviews...

Michael Ross (8/24/2009)

---

Rerunning queries multiple times and clearing the cache? Is that REALLY necessary every time? That just leads me to believe that the developer really doesn't...

R. C. van Dijk (8/24/2009)

---

I totally agree that this is what should be done first! That is even one of the biggest reasons why we always want access to the...

Actually, the first thing I would do to debug it would be to have the stored proc run in the actual environment in sql query editor (assuming it's not a...

Mike C (5/13/2009)

---

There's always more than one way to skin a cat. The question is twofold: (1) What's the performance of the alternative solution and (2) is the...

William Hutton (5/12/2009)

---

I think it's just a matter of ...elegance? To me using Row_Number() statements (and CTEs in general) are easier to write and easier to follow in specific situations...

In what way was simple set logic unable to perform this operation? It looks like this could be solved with left outer joins and is null tests. I...

I find the example disingenuous. You CANNOT use a sample query of "select.. from titles join authors" as an example of a place not to use table aliases. ...