| |
| |
| |
|
Page: 1 2 3
Comments:
<0> so, the answer is 'no, there is nothing in ms-sql that is the equivalent'
<0> BlackArro : this is the point you should be reading your documentation before asking any further questions
<1> ok YuppieScm. I read the books on line but I found only CONTAIN(field, 'keyword') and CONTAIN(field, '"keyword*"') but *keyword* doesn't work
<2> doh
<0> BlackArro : paste an example of the data and an example query to the paste site
<1> YuppieScm, i'm reading sql 2005 books on line to find a solution.
<0> BlackArro : paste an example of the data and an example query to the paste site
<0> BlackArro : once i can *see* what you're trying to do, i might be able to give you a better answer. if the answer i already gave you doesn't work, then you're obviously doing something different to what i thought
<1> YuppieScm, i did the paste
<1> Can you see it?
<0> BlackArro : not until you paste the link to it in the channel
<1> http://sql-servers.com/nopaste/?show=336
<0> ffs...
<0> BlackArro : paste an example of the data and an example query to the paste site
<0> BlackArro : now... guess which bit you didn't do
<1> One moment. I have some network problems and I can't reach the database server.
<1> I write an example by hand
<0> BlackArro : the example query is no use without example data
<1> yes, I understand but I can't reach the database with remote admin. It seams the operating system is crashed.
<1> YuppieScm, i'm sorry but at the moment I can't reach the DB. Maybe, we can continue later.
<1> Thanks for your help :)
<3> may i ask why mysql is banned from this channel
<0> bosie : no, you may no
<0> t
<3> ok
<4> how do i attach a sequencer to a certain table in postgre?
<4> sorry, sequence
<4> solved sorry
<5> madsage fuc*** my a$$
<5> cojones, how big do u think your balls are?
<5> puppet
<5> i am a puppy pedophile
<5> yuppie, scumbag
<6> I have 3 columns (id, speaker, quote) and all of them were created using the 'not null' attribute. i issued a command to insert int id and speaker and it goes through. if quote isn't null, what is it?
<5> default
<5> :P
<5> fubar ***hoe
<6> shouldn't it cause an error?
<5> NO
<6> since that field isn't supposed to be null?
<5> you are wrong
<5> i am right
<5> any other opinion?
<6> well... i put you on ignore. anyone else know the answer?
<5> you missed something
<7> zapnroger what do you mean
<7> "quote" ?
<7> empty quotes?
<6> i just made a table of quotes.
<6> person that said it
<6> and the quote
<6> nothing to do with "
<7> ok
<6> sorry about that.
<7> so what is your question
<7> you want to know what "not null" does?
<6> doesn't it keep the user from inserting blanks?
<6> if that's the case, shouldnt there be an error if I do not insert into every column that has "not null"?
<7> not blanks
<7> NULL
<7> no
<7> because not null just makes sure you don't insert a NULL value into that specific field
<7> you have to give it some value
<6> ah. what do I use if I do not want an empty column?
<7> define empty column
<6> basically, i want to force the user to insert something
<6> is that bad practice?
<7> "" is something
<7> it is a value of 0 length
<7> heh
<7> if that is what you want then do it zapnroger
<7> you can use constraints
<7> or do the constraints for the columns before it reaches the sql server
<7> it's up to you
<6> i see. thanks.
<1> hi all
<8> hi, i got a general question about SQL databases. how do they scale ? ***ume a query such as "SELECT * from db where somefield = '1'". i played around with it a bit an it works fine with small data samples, but i dont know how to find out how well it scales with millions of datasets. any suggestions ?
<9> if you got an index on the column in question, and it got high selectivity, it will perform well
<9> if you got no index, or low selectivity, it will do a table-scan
<10> Depends on what somefield is and how unique the values are.
<11> insert a million records and then try
<10> Which is what I ***ume LVK is referring to when he says "selectivity"
<9> yes
<9> high selectivity = values spread out reasonably well
<8> im sorry, im not doing many database things and dont know much about it, its more a feasability question
<9> low selecitivity = the same values are reused many times, like an index on a boolean column
<8> the field would not be unique
<9> social security number column = high selectivity
<8> imagine it as a phone book, and the field would be 'person x has this number saved'
<11> twisti: add a million dummy records and try it yourself
<9> *** column (male/female) = low selectivity
<8> i ***ume the selectivity would be about 60 or 70 datasets with about a million different index fields, so about 70 million datasets
<9> you mean rows
<9> not datasets
<10> LVK: social security number should be encrypted, tho, so no/encumbered indexability ;)
<9> hash it down to 1 bit
<9> ultimate security
<11> why would you encrypt a SSN?
<8> yes, sorry, rows
<9> just answer this question: do you have a social security number?
<10> Because of laws that stipulate that you have to.
<11> what country are you in?
<10> US
<11> then you're misunderstanding the law ;)
<10> No, our clients are, and that's all that matters.
<8> ok, this is a better example: 1 million users each enter 50 phone numbers they have saved (numbers of other users), now i want a user to be able to search for all rows that have his number saved
<11> i can ***ure you that your bank does not encrypt your SSN
<10> But our clients are of the largest banks in the country.
<8> in what i think is called an m:n database style
<10> I can ***ure you that many of them require it of their vendors.
<11> halo: ha you work in the banking industry too?
<10> Yes.
<10> It's become particularly bad lately since dumb***es lost craploads of backup and transmission tapes unencrypted.
<11> transmission of SSN requires encryption. not storage
<10> And many banks require encrypted storage
<8> i guess my real question is, will this scale linear or exponentially ?
<8> as in, if i have 2 mil users instead of 1 mil, will it take twice the cpu power or 4 times ?
<11> twisti: it depends on the data, like everyones been trying to tell you
<10> They use the nebulous requirement of "encryption at rest."
<8> Slade: was my example not precise enough ?
<11> if you're searching an indexed field it should be pretty linear
<8> alright, thanks
<11> banking industry scares me in terms of how bad security of data is tho :/
<10> Slade: Actually running into a situation now where a lot of our clients are being hammered because the banks are not accepting encrypted file systems as sufficient for database level encryption. Actually had one stipulate that if they open a prompt to the DB and run a SELECT statement that they don't want to see real data.
<10> I know. Their systems generally don't support encryption at all. Some are hacking **** in at the front end.
<10> I think they're overcompensating so that they can appear vigilant and avoid government involvement ala HIPAA
<10> oh well, brb
<11> err.. hipaa is health insurance..
<6> i have a column called prices full of floats with numbers that range from 6.99 to 19.99. when I use "where price between 6.99 and 12.99" in my query, i do not get anything with 6.99 in it. what gives?
<6> actually, the column is called price
<12> Anyone mess with SqlCacheDependency
<0> zapnroger : why are you using floats and not a type more suited to currency values?
<6> yuppie. what would you suggest. even if it wasn't currency, the fact that it is giving me this problem is still bothersome
<0> i would suggest using numeric()
<7> zapnroger if you insist on using floats
<7> i would try to round the float to 2 decimal places
<7> as you want it to be seen
<7> then compare
<6> i don't have to use floats.
<0> then don't use floats
<6> i'm a programmer so i though that's what you are supposed to use
<7> problem solved
<7> why does calling yourself a programmer mean you're supposed to use floats?
<7> you lost me
<6> when we declare numbers that have decimals, we usually use floats
<0> zapnroger : then you're a crap programmer
<6> uh huh
<6> do you guys even know how to program?
<7> zapnroger i've been doing it all my life
<6> do you use ints for everything?
Return to
#sql
or
Go to some related
logs:
#gamedev
odds are bullshit
#politics
#stocks
www.foreverdayphotos
bad-symbol
#politics
#beginner
#networking
#windowsxp
|
|