| |
| |
| |
|
Page: 1 2 3
Comments:
<0> in SQL Server 2000, if I create a new function and then try to use it, SQL Server throws an error unless i specify the user that created it. For instance, if the user it 'bob' and the function is 'myfunc', simply calling myfunc() fails, but bob.myfunc() works fine. Is there any way around this?
<1> right
<1> dbo.Function()
<0> that will always work, regardless of who made it?
<1> i think so
<0> just tried it, doesn't seem to :-(
<0> returns 'invalid object name'
<0> ahh.. but if i explicitly create it.. so CREATE FUNCTION dbo.myfunc(........) then it works fine
<0> thanks
<2> hrm ... I'm doing a SELECT from a table and want one of the result columns to show the greater date value from two different columns in the same table. I'm trying to figure this with IF or CASE statements (MSSQL) but not having much luck.
<2> got it
<3> * Pun|sher (ircN@c-24-63-247-132.hsd1.ma.comcast.net) has joined #windowsxp
<3> <Pun|sher> hey is it possible to use a pcie card on an agp board
<4> is it possible to do a join between 2 different databases on the same server in sql server 2000?
<5> yes
<6> happydude : yes
<6> happydude : read up on the full syntax for select to find out how...
<4> k just wanted to know if it was possible before i did a lot of reading
<5> do the reading either way
<6> happydude : reading is good
<6> happydude : always read *first*
<6> happydude : even if you don't find what you're looking for, you'll find something else...
<7> hi
<7> 4 ?
<4> i don't see anything in the docs about defining database syntax
<1> http://www.wally.com/jumpCh.asp?idUser=0&idChannel=44&idLang=IT
<1> ^^ check out the video
<1> makes you wanna earn those millions doesn't it?
<8> looks like its from a bad hulk hogan and rody piper TV series...
<9> hoom
<9> http://sql-servers.com/nopaste/?show=163
<9> should raiserror be called prior to rollback tran?
<10> IT
<10> IT IT IT!
<1> jarett: so you woldnt' want one like that?
<8> Quant, fast boats like that are like expensive sports cars. They are for short men with small ****s... aka sales people and managers
<4> is the cost higher for a join between databases than between 2 tables in the same database?
<8> happydude, yes
<4> is it significant?
<8> but it depends on the DB as to how much more
<4> sql server 2000
<8> some DBs are smart enough to p*** the where clause crap over
<11> Also depends on if the DBs are on the same machine or different machines.
<4> oh sorry i meant to say that they're on the same machine
<4> so is a join with 2 databases on the same machine a bad idea?
<8> if you can do it in the same database, do it
<4> that's not an option in this case
<4> i'm just trying to find out if doing it across the databases will be slow
<8> even in the same database can be slow.. if you are a crappy dba or programmer
<8> you are the weakest link
<10> happydude in sql 2k it does not matter where the tables are logically.. it only matters physically
<4> that's good to know
<10> if they're both in databases that are on the same physical array then the speed will be the same
<4> that's what i was hoping
<10> whether they are in the same database or not
<10> it doesn't matter
<10> having a good index will have the greatest performance impact
<4> thanks for the info
<10> that's even true across instances that are on the same server as long as there is enough RAM to cache the result set from the "remote" instance
<4> same server different drives?
<10> it's all about I/O
<10> if the tables are in databases that are on the same drive it will be generally slower than if the two tables are in databases that are on seperate drives
<10> and if you're doing inserts, updates, deletes it also matters where your log is
<4> wait same drive would be slower than separate drives?
<10> imagine this:
<10> one server, two drives, drive a and drive b
<10> database a is on drive a
<10> database b is on drive b
<10> both drive a and b are similar performance
<10> if you do a join between a table in db a and a table in db b
<10> the sql server can read from table a and b virtually at the same time
<12> Same applies to two tables in one db
<10> if they are both on the same drive, then I/O for table b has to wait on table a I/Os and vice versa
<4> that makes sense
<10> if the two tables in the same database are in seperate file groups and those file groups are each on seperate drives then you can see the same performance gain
<4> but the join between databases on the same drive and the join between tables on the same drive should take about the same time
<10> right
<10> now if it's a disk array.. like a RAID.. then it might not matter
<5> what other type of disk arrays do you know of
<5> they aren't.. like a RAID..
<5> ?
<10> smart raid controllers order requests for better efficiency
<12> Darken: JBOD
<5> happydude you don't select from databases
<10> LVMs, Volume Sets, etc
<5> you select from tables
<10> JBOD
<5> what are you selecting?
<5> you can't
<5> :/
<10> FEEL THE PAIN
<5> database is not a source
<5> a table is
<5> there is no pain to feel
<12> Could be a remote database, in which case the rules change entirely.
<10> joins between tables on different servers should pretty much always be avoided
<10> taps just played at ft myers
<13> yo
<14> hello
<14> i try to
<14> make som select string in sql
<14> but most i bee connectet
<14> to a server for
<14> make a
<14> base
<14> raight...
<14> ohh
<15> wow that made no sense at all
<16> good stuff
<14> ohhh
<15> I think I might go back to sleep after reading that. Heh.
<14> **** u
<14> ii try to make things in dsql
<14> nono...
<14> hehe
<17> http://www.phpriot.com/2563
<17> Can someone shed a light on that?
<6> D-dock : did you read the rules?
<18> hi
<18> SELECT * FROM mytable WHERE LOWERCASE(nickname)='Fa1nT'
<18> does it work?
<19> WHY DONT YOU TELL US
<20> if there were a function in your dbms named LOWERCASE
<20> and you had a table named mytable
<19> and why would you compare lowercase to a string with caps in it ?
<18> I explain what I want to do
<11> Usually a good place to start.
<18> I want to search in my table all Fa1nT fa1nT or fA1nT
<18> but not Fa1nT---
<18> for exemple
<18> understood?
<20> yea
<18> how can I do please?
<19> how about you state your database too
<20> so you want to search for all Fa1nT fa1nT or fA1nT
<20> but not all Fa1nT fa1nT or fA1nT
<20> unless its all Fa1nT fa1nT or fA1nT
<18> ?
<5> haha phargle that's cruel
<18> that's more stupid than cruel
<12> Not exactly rocket science, LOWERCASE('A') != 'A'
<19> i wouldnt even piss on this guy if my bladder was splitting
<5> Fa1nT go test your statement and debug it, then come back here and tell us your results
<19> go away, read a manual or summat
<21> if you ran oracle... you could just search phonically since people like you are expected to be stupid and not able to spell. so the database makes up for it :P
<5> then you can Fa1nT faint FA1NT Fa1Nt
<18> What I want is used in any script of suscribtion
<12> Jarett: What algos does Oracle use for that?
<18> to find in table if someone is registered or not
Return to
#sql
or
Go to some related
logs:
#nhl
r3n4t0
#politics
flash texthtml bold
#beginner
#computers
asseecc
#freebsd
#worldcup
#freebsd
|
|