aravind-305595 (7/9/2010)

---

Hi, Thanks all. I thought to re-write that piece of code with suggestion given in this forum. Now I face another issue with the joins, my code looks like,

update...

oliver.morris (7/9/2010)

---

Hi,

Thank you for your continued support. I already have Alastair's superb book.

I have attached the 3 execution plans to for the 3 queries in your post. They all use...

Not that I'm aware of, but then I miss the hardware/server stuff sometimes.

Tom Robertson (7/8/2010)

---

I hear what you are saying with not having a great comparison, but I really think the hardware is not the issue.

the reason I think that is because

A)...

Sharepoint most definitely has to run as 'sa.' I've never seen anything to suggest otherwise and everything I've seen it do on the server pretty much suggests that's how it...

I wish I could say yes so you'd buy a copy, but no, it doesn't cover spatial queries. If you don't have a copy of Alastair Aitchison's excellent book, I'd...

Tom Robertson (7/8/2010)

---

Thanks for the ideas guys,

I neglected one important piece of info. The development workstations are running sql 2008, database is in 2005 mode

production servers(I've tested 3 different ones...

You're basically completely out of luck.

You might be able to query the cache to see which procedures might have a last run time near the time of the data loss...

PowerShell! Microsoft is starting to set up a two-tier system of administrators and super-administrators. The differentiator is PowerShell. You want to be in that second group if you want long...

The problem is, it's not a question of having a function that can do what you need. The issue is how is the data stored and retrieved and can you...

Jim McLeod (7/8/2010)

---

A major difference between your development and production environments could be CPU resources, specifically the number of cores. It's possible that in production the Maximum Degree of...

Looks like you're getting deadlocks due to the SELECT, EXEC, INSERT...SELECT process that both queries are running. Each one could put shared locks on identical rows in the initial select...

Interesting discussion and not going the way I would have expected.

Since part of having a dev, qa, staging, prod environment seperation is testing the code and testing the deployment process,...

One thing at a time. The query plans you posted were for a query without using the STIntersect command. I'm comparing apples to hammers with that. I'd need to see...

Right, neither version of the query are using the spatial index. All you've got are table scans. First thing I'd try is using the derived table like I showed before....