| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> for the sql to display just the bad stuff i need to do something like
<0> where hitprobiblity > 50
<0> i cant do that becase i dont have a colunm of that name
<1> i think you need to hire a programmer
<0> and i cant create one becase the first step to makeing one is to convert
<0> 4294964823 to unsigned
<0> does that make sense so far Darken| ?
<1> 1 second
<0> k
<1> is 4294964823 a valid number
<1> or did you make that up
<0> made it up
<0> let me post some sample data on no paste
<1> listen scatterp
<1> i'll make this very
<1> utterly simple for you
<1> then i'm leaving before you make me shoot myself
<2> let me check, yes my sources say that 4294964823 is a valid phone number
<0> http://sql-servers.com/nopaste/?show=341
<1> if the highest bit is a 1, you need to do a 2's complement and then keep record that this number IS a negative number
<1> if the highest bit is a 0, you can read the value as if it were unsigned
<1> bye
<0> ok
<0> thank you
<1> and fire your programmer
<0> so 8529408 is 100000100010011000000000 the last number is a 0 so in that case the highest bit is 0 ?
<1> no
<1> 0 is the LSB
<0> or is it the first number i need to be looking at ?
<1> you want the highest bit, HSB
<0> ok
<1> if you are working on intel architecture
<1> you want the first bit in memory
<1> endian matters
<0> so do 2`s complent and i have the answer ?
<1> 2's complement will convert signed -894 to +894
<1> which can be read as unsigned
<1> ok?
<0> ok yes makes sense i think i got it
<3> is there a chan for database design?
<3> nm then :)
<0> how would i convert my int to binary ?
<4> CAST(int_field AS BINARY(4))
<5> The query here http://sql-servers.com/nopaste/?show=342 is taking 17 seconds to run. any obvious ways of making i faster?
<0> thx Halo_Four
<6> good afternoon folks
<0> Halo_Four SELECT CONVERT(iAttribute AS BINARY(4)) AS iAttributeA
<0> incorect syntax it says
<6> try to do it without specifiying the size of binary
<4> er, CAST, not CONVERT
<6> bah
<4> er, I said CAST originally
<4> Try copying my examples correctly :P
<0> oh
<0> :/
<4> Interestingly enough MSSQL will always convert to big-endian.
<0> Halo_Four i got a colunm containing <binary>
<0> over and over
<4> In Query Analyzer?
<7> t
<0> in server enterprise manager
<4> Probably doesn't display the binary data
<0> hmm
<0> but query manager would you think ?
<4> You should be able to see the values in Query Analyzer
<0> ok
<8> arrrr
<8> So, how worthless is a set of database clusters that are only plugged into a single switch?
<8> Keep in mind, there are redundant switches in the enterprise, just nobody thought to plug the cluster nodes into each of them.
<8> this place is soo amatuer.
<8> the "Engineer" was shocked and amazed when I asked him to plug them each into different switches.
<0> Halo_Four it gave me results in hex
<4> That it does.
<0> hmm i wanted binary :/
<8> lol
<4> You're not going to get "110110101011"
<0> hmm why doesnt this danm mssql do anything the way i want lol
<8> again, lol.
<4> Because you have a warped perception as to the duties of a database server? <shrug />
<0> lol
<8> reminds me of the guy who came in here bitching about not being able to group/order on binary data...
<4> dr: Oh no, this one is much better.
<8> hehe
<8> trade you for an engineer who doesn't know jack.
<8> you should have seen his head explode when i asked him about using our dual port nics to bond for fault tolerance...
<8> im so outta this job after a year or so.
<4> These guys apparently mashed a bunch of pieces of data into a single int32 field and now want a quick and easy way to extract it.
<8> hahahahahaha
<8> yeah, rotsaruck with that.
<0> Halo_Four yes thats it :)
<0> you got it
<4> Quite possibly.
<8> im tempted to post my 'cluster' woes of late, but too many people from the office read it.
<4> Even better
<8> its tempting, thats for sure.
<4> I came close to posting a bit of VB6 I ran across.
<8> you should, code can be anonymized much easier than blatent personal/technical incompetence.
<4> This code was written by my boss and he has a very unique style ;)
<8> hahha
<8> "My kung-f00 is u-neeq"
<9> crappy code is unique style... :P
<10> if i "archive" my sql table, is it a good practice to reset the PK inital value back to zero?
<8> on a good note, i got my 'mirror' sp almost done.
<6> good codes utilizes known patterns :)
<9> sort.exe "%x%x%x%x" run that in windows :P
<8> d2d, highly overrated...
<6> come to think of it, my codes are too unique meaning...
<9> thats "patterns" for you :P MS and their stupid pattern overflows
<6> drhyde^:: well it works out sometimes
<8> hehehe, i was being sarcastic.
<6> well i don't believe in MS ***PRACTICES*** which is what they call
<8> haha
<6> :) i know drhyde^
<8> MS Kludge'ry
<9> yeah sad they dont know how to use printf :P
<6> my comp keeps on freezing.. stupid steam...
<8> eh?
<6> "steam" by Valve
<6> i am trying to reinstall Counter STrike source... and it's such a headache to use steam
<6> brb
<4> Yeah, Steam is horrible
<9> you know what else i love about MS?
<6> bill gates?
<9> http://www.google.com/search?q=ext:rdp+rdp+%22screen+mode%22&hl=en&hs=i8X&lr=&client=firefox-a&rls=org.mozilla:en-US:official&start=10&sa=N
<9> that
<9> remote desktops are always allowed through windows firewall.. AND the connection files are easily googleable and plain text
<4> Yes, but Remote Desktop is not enabled by default, and web Remote Desktop isn't installed by default.
<9> ummm it is enabled by defaiult on most OEMs
<4> Actually, RDP isn't allowed through Windows Firewall by default
<4> No it's not.
<9> it is on most dell, gateway and thinkpads ive seen
<6> you have to go to properties soemthing and allow rdp
<4> Never seen it enabled on a Dell
<6> it's not enabled
<4> And users without a p***word can't use RDP
<6> 90% of computers at work are dells and none of them have rdp enabled
<6> by default that is
<6> for both win2k, and winXP(well both 32/64bits)
<10> if i "archive" my sql table, is it a good practice to reset the PK inital value back to zero?
<4> k00: No
<10> why
<4> Why would you?
<10> to keep the ids from getting too m***ive
<4> Unless you didn't scale your datatype appropriately it's not like that matters.
<10> is it ok if the id grows to 400000000000
<4> If you're using a BIGINT, sure.
<10> what if im using regular int
<4> Then it can't reach that size.
<6> then change your db design
<10> whats wrong with reseting the inital value
Return to
#sql
or
Go to some related
logs:
intrin efnet
#hardware
#winxp
#linux-noob
quotes of nitchze
#delphi
vista problems with GeForce6150
#gentoo
#gentoo
#beginner
|
|