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....

Jeff Moden (7/7/2010)

---

Tom.Thomson (7/7/2010)

---

I've...

I'm completely missing the point of the questioner over here. Can someone else give them a hand maybe?

For a low-end system, not lots of server or lots of requirements for monitoring & alerting, you really can't go wrong with Red Gate SQL Alert. I do still think...

a.borgeld (7/7/2010)

---

But you have to script the views one by one? And then i think the easyest way is to clipboard and then paste it one by one in one...

Yep, that's the way I thought it worked too.

oliver.morris (7/7/2010)

---

Hi,

I have a scalar function that works ok, it's just that its slow. I have indexed the geom column but it can take upto 40 mins to run on...

Pretty much, you can all this with SQL Server. SQL Agent can generate emails when jobs fail and you can generate emails when you get errors. The only trick would...

The basic commands will work. As you get into more complicated scenarios, some things will work and some won't.