Greg, On 4 March 2016 at 18:03, Greg Keogh <gfke...@gmail.com> wrote: > Folks, anyone using Azure Tables Storage in anger? I really like it, simple > and effective. > > What is the query syntax equivalent of SQL "not null", that is, a row has a > named property? I have a table with tens of thousands of rows, but only a > small percentage contains a property value named ErrorMessage, and I want to > select them only. Going ErrorMessage neq "" works but it's too ugly to > believe there isn't a better way.
On 7 March 2016 at 10:08, Greg Keogh <gfke...@gmail.com> wrote: > However ... I need some way of finding > all the rows with an ErrorMessage property. If there is no way of doing this > without a full table scan, then it hints that I'm using the facility > inappropriately, in a "relational" way that it doesn't support. On 7 March 2016 at 13:38, Thomas Koster <tkos...@gmail.com> wrote: > With NoSQL databases, you must not fear duplication if you want more > than one query to run efficiently (better than linear time). This is a > trade-off you have full control over, which is a good thing. A covering > index in a relational database also duplicates data to avoid row-id > lookups. This is not much different. I stumbled upon this MSDN "Patterns and Practises" page that describes what I am talking about. https://msdn.microsoft.com/en-au/library/dn589791.aspx