How to Query Big Data From SQL Server -

-

in table entries there 200w data in 2015-02-18.

in table entries there 250w data in 2015-03-18.

how can query data table entries, string of entrytext has same in 2015-03-18 not has same string in 2015-02-18`?

i used below statement, slow:

select        entrytext  entries  convert(date, datecreated)='2015-03-18' except select        entrytext  entries  convert(date, datecreated)='2015-02-18'

you can use first query desired result:

select        entrytext  entries  convert(date, datecreated)='2015-03-18'

Comments

Post a Comment

Popular posts from this blog

node.js - How to mock a third-party api calls in the backend -

-
i'm testing application mocha , supertest, test like var request = require('supertest'), app = require('./bootstrap.js'); describe('...', function() { it('...', function() { request(app) .get('/some/url') // ... }); }); the bootstrap.js real application before listen ports all works perfect have add calls third-party api , testing slow so when do, test example takes 5 seconds request(app) .get('/my/endpoint/that/makes/call/others') // ... how can make fake calls during test real when running application? you can use nock purpose.
Read more

amazon web services - Installing MobileFirst 7.0 server on AWS -

-
are there instructions installing mobilefirst server 7.0 on aws ec2(amazon web services). found article ( https://www.ibm.com/developerworks/community/blogs/worklight/entry/how_to_install_worklight_server_on_amazon_ec21?lang=en ), seems outdated latest versions. appreciate if has generic document installing mobilefirst on cloud services aws. mobilefirst platform foundation 7.0 not different worklight 6.2 etc, it's same new features, etc. you setup account ec2 vm, running linux, , mfpf supports linux. nothing different perspective. meaning, blog post you've found true mfpf 7.0.
Read more

Non Unique Username with ASP.Net Identity 2.0 -

-
i have situation username not unique. email used username , 1 email can have many different passwords in database , legitimate. how use asp.net identity 2.0 in situation. var result = await signinmanager.passwordsigninasync(model.username, model.password, model.rememberme, shouldlockout: false); above line expects 1 user in database. if multiple records returned - returns failure. expected logic doesn't work me. how override logic? alternatively, ready customize login problem - not sure things done part of passwordsigninasync. adding cookies etc. please help. i made work. had use username + password combination unique username. these different situations in industry different types of needs.
Read more