Re: Azure Table query "not null"

2016-04-05 Thread Thomas Koster
On 4 March 2016 at 18:03, Greg Keogh 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 > s

Re: Azure Table query "not null"

2016-04-03 Thread Greg Keogh
> > 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 > I like that article, it's sensible and it describes when you should and should not use the technique of making artificial indexes to

Re: Azure Table query "not null"

2016-03-31 Thread Thomas Koster
Greg, On 4 March 2016 at 18:03, Greg Keogh 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 onl

Re: Azure Table query "not null"

2016-03-06 Thread Thomas Koster
On 4 March 2016 at 18:03, Greg Keogh 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 > s

RE: Azure Table query "not null"

2016-03-06 Thread 罗格雷格博士
mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<http://www.sqldownunder.com/> From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Monday, 7 March 2016 10:09 AM To: ozDotNet Subject: Re: Azure Table query "not n

Re: Azure Table query "not null"

2016-03-06 Thread Greg Keogh
ent). > > Regards, > > Greg > > Dr Greg Low > > 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 > fax > SQL Down Under | Web: www.sqldownunder.com > > -Original Message- > From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-b

Re: Azure Table query "not null"

2016-03-06 Thread Greg Keogh
gt; > Dr Greg Low > > > > 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 > fax > > SQL Down Under | Web: www.sqldownunder.com > > > > *From:* ozdotnet-boun...@ozdotnet.com [mailto: > ozdotnet-boun...@ozdotnet.com] *On Behalf Of *Greg Keog

RE: Azure Table query "not null"

2016-03-06 Thread 罗格雷格博士
| Web: www.sqldownunder.com<http://www.sqldownunder.com/> From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Monday, 7 March 2016 9:46 AM To: ozDotNet Subject: Re: Azure Table query "not null" Hi Ian et al, I reckon most of th

Re: Azure Table query "not null"

2016-03-06 Thread Greg Keogh
on SO – see the side-panel links to > other questions on null testing) some of which lead to Microsoft guides, > which may be helpful. > > > > Ian Thomas > > Albert Park, Victoria 3206 Australia > > > > -Original Message- > From: ozdotnet-boun...@ozdotnet.com

RE: Azure Table query "not null"

2016-03-06 Thread Ian Thomas
From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Low (??) Sent: Sunday, 6 March 2016 10:19 PM To: ozDotNet Subject: RE: Azure Table query "not null" Hi Ian, It’s a tough question. For me, the biggest issue is where th

RE: Azure Table query "not null"

2016-03-06 Thread 罗格雷格博士
zdotnet.com] On Behalf Of Ian Thomas Sent: Sunday, 6 March 2016 6:45 PM To: 'ozDotNet' Subject: RE: Azure Table query "not null" I wondered about Azure SQL vs Azure Table Storage pros and cons, and to lessen my ignorance looked at a few Q&A at Stackoverflow. This par

RE: Azure Table query "not null"

2016-03-06 Thread 罗格雷格博士
ject: Re: Azure Table query "not null" On 4 March 2016 at 18:03, Greg Keogh 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 >

RE: Azure Table query "not null"

2016-03-05 Thread Ian Thomas
--Original Message- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Thomas Koster Sent: Sunday, 6 March 2016 5:27 PM To: ozDotNet Subject: Re: Azure Table query "not null" On 4 March 2016 at 18:03, Greg Keogh < <mailto:gfke...@gma

Re: Azure Table query "not null"

2016-03-05 Thread Thomas Koster
On 4 March 2016 at 18:03, Greg Keogh 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 > s