Great statement I ran into somewhere, "That man's as subtle as a two-by-four upside the head."

On the subject of "nothing to hide, nothing to fear", there's another aspect to it: Nobody, and I mean nobody, wants to know certain things about certain people. I...

I can easily imagine the inventor of the filing cabinet having similar qualms about "ease of data abuse" and "ease of data corruption".

I can also imagine the inventor of writing...

On the subject of terrabyte flash drives:

http://www.enterprisestorageforum.com/technology/news/article.php/3795956

Looks like it'll be a lot less than a decade.

On the subject of cloud databases, I think it's a cool idea, but I just...

Sometimes it takes a separate set of eyes to pick these things up.

One thing I always do with dynamic SQL, is have a print command right before the exec command....

Is there a column in RoutePosition that would satisfy the range of the query? Perhaps an index with a column like that would help.

It's the union all operation that's slowing it down. Or so it seems to me.

Try dumping the data into a single table, in a test environment, with that index...

Bob Hovious (2/27/2009)

---

I was referring to inadequacies of alleged IT professionals 😉

My war story is that our development group used to have a guy whose...

karthikeyan (3/2/2009)

---

I have tested the remaining queries with both index. Both of them took the same time to complete the execution. only difference is 'FORWARD SCAN' and 'BACKWARD SCAN' method...

Why are you executing your Where clause? "exec (@iWhere)". From what I can see, that's just a set of boolean comparisons, without a Select, etc. Do you...

Roy Ernest (2/27/2009)

---

Atleast they did not make the cardinal sin of no back ups. He is a developer. Still had sense to back up the DB while there are DBAs...

Yes, you can create a layer to expose a proc through a web service. People do it all the time. It comes under the heading of building something...

They know how to do backups, but not how to restore them. They also think you...

Easier with a case statement. There are only so many variations on the interval.

case @Type

when 'dd' then dateadd(day, @Number, MyDate)

when 'ww' then dateadd(week, @Number, MyDate)

...

Connect to the database using any standard method, and run the proc using the methods and properties appropriate to your programming language. Not sure what else you would do.