Trust me if it were only that simple. I have made such suggestions on proof of concept type stuff and I'll load it up and push and stretch the...

Thanks for the response.

Your reply made the penny drop and rather than view the clustered index as an index and therefore index seeks/scans if I think of it as an...

The problem is not so much of a matter regarding how to either improve the coding or how to integrate the data to and from the handhelds. This issue...

Trust me you don't want to know what's going on but here is a quick answer.

A SQL db is used to populate a handheld device. A number of DDL...

Thanks... I have always taken this approach, to implicitly order a query result however this environment which we are trying to improve has a whole raft of bad practices which...