Viewing 12 posts - 1 through 12 (of 12 total)
Okay, so I updated my SQL Express to SP1 and then decided to also add cumulative update #7 for safe measure. Unfortunately it has not had an impact on...
January 10, 2014 at 6:16 am
Grant Fritchey (1/8/2014)
January 8, 2014 at 2:11 pm
radek.hruby (1/8/2014)
Maybe something like computed persisted columns:
...,
Lat AS ([LatLon].[Lat])...
January 8, 2014 at 1:55 pm
I added a zip file to my first post that has what you need to recreate my testing DB.
Mike
January 7, 2014 at 11:25 am
radek.hruby (1/7/2014)
I'm looking at the execution plan and wondering what those exclamation marks means on index seeks.
The exclamation marks are giving me a warning that there are no statistics on...
January 7, 2014 at 10:30 am
radek.hruby (1/7/2014)
On the first sight this seems to be a good candidate for Common Table Expression http://msdn.microsoft.com/en-us/library/ms175972.aspx . Maybe worthy to try.
I admit that CTE's are not my strong suit...
January 7, 2014 at 9:47 am
Grant Fritchey (1/7/2014)
So, you're not getting table scans, but the performance is still really bad? It may just be your process then.
Here is the base for my process. This...
January 7, 2014 at 8:55 am
Grant Fritchey (1/6/2014)
January 7, 2014 at 5:18 am
TheSQLGuru (6/19/2013)
Seems like further clarification of the needs is required. Should "chained" intersections be allowed/considered as one group? Or discarded.
TheSQLGuru (6/19/2013)
June 19, 2013 at 1:16 pm
Okay, I am a little dissapointed. I had read how efficient and fast recursive CTE's are compared to CURSOR's, however when I run the CTE against my data set...
June 19, 2013 at 6:09 am
Mark-101232 (6/19/2013)
Here's another way using recursive CTEs
Now this is what I was hoping for. Thanks Mark! I am still trying to wrap my head around recursive CTE's and...
June 19, 2013 at 4:53 am
TheSQLGuru (6/18/2013)
This solution was pretty quick to slap together and seems to do the trick, although I must admit to feeling slightly dirty posting it! :hehe:
Thanks Kevin. I...
June 19, 2013 at 4:43 am
Viewing 12 posts - 1 through 12 (of 12 total)