| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> seems to have 1000 columns
<1> heh. ecarroll, what you are saying makes no sense to me in an rdbms world. try SQL 101
<0> ermm
<0> how about trying reality first?
<0> if you're going to go about spouting bs and pretending everybody else is stupid
<1> anyone who talks about tuples with regards to rdbms sounds as if they are doing a paper on it, or as if they are playing on the wrong field
<0> at least use real world scenarios
<1> if you were talking about OLAP cubes on the other hand...
<1> 1row:1column ... I'll remember that
<0> lol
<2> i <3 cubes
<3> If you have a one to many does the data on the one get replicated to the many or not on transmission?
<2> if you have 10k items (with like 3 columns), 1 manufacturer (with 5 columns), then it will return 10k rows with 8 columns
<4> no its on nocturnal emission when that occurs
<3> thats linear and thats what I was asuming.. so where is this misunderstanding on my part of joins?
<2> 20k columns
<2> <3> Inge-: 20k rows, with 20k columns returning the result of the join, aka 2 column per tuple. or 10k rows with 10k columns for 1 select, and 1 row with 1 column for a second select resulting in 10,001 columns
<2> that statement is gibberish
<3> 20k rows, with 1 column a piece is 20k gross columns, where 9,999 is redundant.
<1> Whatever dimension ecarroll is in, it has no connectio nwhatsoever with the dimensions of this world
<1> um
<1> so
<4> ecarroll_: see my answer above
<5> how can i tell the approximate buffer numbers used by some relation given the hit rates for any buffer replacement policy
<1> vinsewah: you don't. you ask. then we tell you. the answer is 77.
<4> lol
<5> huh
<5> oh right. thats was a wisecrack
<6> sql 2000 .. i'm trying to do a bulk insert from a recently added shared network drive.. sql is telling me " could not be opened. Operating system error code 5(Access is denied.)
<6> which user account do i have to give rights to so that SQL server has permission
<2> good luck ecarroll!
<7> xloc : the account that the sql is running under
<1> xloc: you could also run BCP from a batch/command line
<0> does anybody here know what would cause windows to suddenly not be able to make any outgoing connections on a certain port
<0> like right now i can surf the web fine
<0> connect to rdc
<0> but ftp stopped working
<8> Arrakis : which port?
<0> outgoing port 21 is dead
<0> nothing can get out anywhere
<8> ah - could be a/v profile
<0> no anti-virus - no outoubnd firewall protection
<2> virus :P
<0> no
<0> cause it happens
<0> like it was working about 2-3 days ago
<8> must be something upstream then
<0> but i've had to reboot my machine - because of it
<0> nah
<0> its something specific to this machine only
<4> do a netstat and see what you have open?
<0> i am rdced into other machine onsame router
<2> maybe some app is installing a lsp and getting screwed up
<0> lsp?
<0> hmm
<2> layered service provider
<2> basically a network hook
<8> Arrakis : so can any other machine on same subnet ftp to a target?
<0> yeah
<0> hmm tenfour does ms or systernals have a program to see which app has a port open?
<4> netstat
<9> Arrakis: What OS?
<2> yea netstat :P
<0> hmm tenfour does ms or systernals have a program to see which app has a port open?
<8> netstat
<9> XP and 2003 netstat will tell you
<10> heh, i have a database, values are being put into it from somewhere (huge, undocumented project) and there are two columns, StatusTime and StatusKey. Status Key can be either "Login" or "Logout" and the other is when it happens.. I need to somehow.. match all logouts with the login that came immediately before it on the same day
<2> yea netstat :P
<9> sysinternals does have an app for 2000
<2> netstat -o
<10> the problem lies in that.. not all the logins/logouts make it into the database, so some of the values should be null
<0> http://www.rafb.net/paste/results/DgxmUe74.html
<0> silly
<0> netstat shows u ips
<8> Arrakis : however, port 21 is the post used on the server, the outbound port will be something quite different
<0> doesnt show what program
<4> -a
<2> -o
<4> netstat -an
<0> yeah YuppieScm
<0> but anything that connects to port 21 is dead
<4> er, /an
<0> but anything that connects to outbound port 21 is dead
<9> netstat -b shows the EXE name in 2003
<8> Arrakis : change the ip addy of the 'broken' box, and try again
<0> i thougtms released a tool that did that
<10> i can do a join so that i get: 1stlogin:1stlogout, 1stlogin:2ndlogout, 2ndlogin:2ndlogout (which has that extra entry in the middle that i don't want) that lets me catch the entries even if one of the login/logouts is missing... but
<0> i need to find out who has all those ports open
<4> ah ****.. netstat in linux shows you user
<8> Arrakis : can this machine connect to 'anything' on port 21?
<0> nope
<4> lsof too.. hrmm
<5> postgre COOLS
<0> outbound 21 is dead
<0> on this machine - even locally
<4> group policy maybe?
<1> outbound 21?
<1> you mean you can't access any other machines port21?
<0> correctumundo
<1> anything you open from you machine would normally be 1024+ range
<0> ...
<0> outbound
<0> meaning going out to port 21
<0> trying to connect to other servers port 21
<4> inge is saying that your local port will actually be xomething much higer
<8> so did i
<4> and yu're only connecting to port 21 on another machine
<0> ths i know
<4> netstat would confirm this
<0> i've done network programming
<0> http://www.rafb.net/paste/results/DgxmUe74.html
<0> ^^
<1> hehe :)
<0> some application is listening on a whole **** pot full of ports
<0> hence why i wnated to find an tool that would show me what app those ports belong
<1> netstat
<1> netstat -o
<0> wee
<10> basic of the query is: http://sql-servers.com/nopaste/?show=254
<0> now just gottta match all this up
<0> with their pids
<1> which you get in task manager
<1> unfortunately it often comes out as svchost
<10> but i can't figure out how to match up the logins and logouts when they aren't... all there...
<0> hmm
<0> wcescomm
<0> has like
<0> 50 ports open
<0> i hate that stupid pos
<10> gyaH!
<0> all i wanted to do was sync to my pda once . and it opens up every sime and wont quit
<0> and opens up a hundred ports
<0> stilldoesnt let me get outbound 21 though
<1> why do you need outbound 21?
<0> ...
<0> because i need to ftp
<0> so i can upload files to ftp sites
<1> uhm
<1> interestingly, you can ftp when logged into a unix box, which won't let you open ports below 1024
<9> What does that have to do with port 21 on your computer?
<1> Halo: don't bug him, he haas done network programming
<0> you guys are the only ones who have said "on my computer"
<0> outbound ..
<0> this computer specifically cannot connect to port 21 outbound anywhere
<0> meaning all ftp is dead
<0> other computer - same network can hit the same sites fine .
<9> Sounds like the other side is stealth rejecting you.
<0> heh
<5> lets say i make a query
<5> SELECT <some attributes> FROM R, S WHERE R.ForeignKey = S.PrimaryKey
<1> can you open port 21 on another machine on your local network?
Return to
#sql
or
Go to some related
logs:
#sex
#directx
#windowsxp
#solaris
#computers
NagiosQL
#beginner
#nhl
#stocks
#sex
|
|