| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> so its possible to make a script that modifies an existing table?
<1> in MSSQL, what is an index spool ?
<2> it represents a temp table created in tempdb, for the machine to use to avoid re-scanning the original, usually for a nested loop, tec
<2> s/tec/etc
<1> i ***ume those are bad (usually)
<2> indeed
<0> argh.. it complains about the keywork GO from the generated sql-file
<3> Because go isn't a keyword.
<3> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_8hf3.asp
<0> okey, but its mssql that has generated the script and it contains GO
<3> No, its enterprise manager that created it.
<3> not mssql.
<0> okay then. but how to interpret the error. Am I not supposed to be able to run the EM-script in mssql?
<4> lets say im building a search and some documents have multiple authors how would i handle that cuz SQL spits out a result for the same doc whenever it has multiple authors?
<5> if you want it grouped by document, then group it by document :P
<0> aaaah cool.. was just to open up the script in QA
<0> sometimes the most obviuos revelations creates a big smile
<4> no i think i dont need the author names at all for a web search
<1> can you create an index on a computed column ?
<4> i wanted to ask you, if i get multiple results for a single doc cuz lets say there are multiple authors and all feilds are the same except the author name there has to be a way to combine that right?
<4> not combine
<4> merge the authors
<5> group by
<5> but then you are dealing with aggregate
<5> so you gotta figure out how you want to deal with multiple authors for 1 returned row
<4> can you explain?
<4> oh
<4> well ican get rid of the authors names all together
<4> if that makes it easier
<5> then don't join to the authors table at all
<4> ahh
<3> Reading the help, but just want to veryify - if you do a full export in oracle, and then import that, it gets everything - users, procs, tablespaces, tables, data, yadda?
<6> yes
<3> hm. This should be relatively easy, other than finding the time to do the export then.
<3> Since my users are picky.
<3> And the poor machine I'm trying to get rid of is not exactly fast.
<7> startkeylogger
<6> heh
<6> if you are more daring you can copy the tablespaces
<3> I'm not daring. I'm not even sure that backups have been done right on the old machine, so I'm so VERY not daring with it.
<3> Its like a sacred cow. DO NOT TOUCH.
<6> you are gonna have fun with imp/exp then
<3> Probably run it over night. Looking forward to that.
<8> evening
<1> can you create an index on a computed column in sql server 2000 ?
<9> Yes, if the computation is deterministic and the appropriate ANSI settings are enabled and remain enabled for every DML statement against that table in the future.
<1> that would probably explain why it was complaining about a quoted identifier
<10> Hi guys ('n' girls), I have an Access DB with a tbl with the columns ID,sCnee and sCnor. Is there a way to get the ID and sCnee values out with only ONE of each sCnee (I tried DISTINCT, but didn't get it to work)???
<8> Jaggernau : use 'group by'
<11> Hm, I really dislike my Router
<0> is it possible to get the fieldname from an index in a record, like rs(1).fieldname or whatever?
<0> jagger: if the distinct does not work, then the records are unique
<12> if i want to search phone numbers that match an area code, am i better off storing the number as a integer or a varchar?
<12> for speed not complexity
<9> Depends on the need. You might want to seperate the different attributes that comprise the phone number.
<2> Excellent suggestion.
<0> can i know how many fields there is in a recordset-row?
<13> count them
<0> how?
<9> Every client library is different.
<0> ok. asp/mssql
<1> even that doesn't narrow it down enough
<0> think i found somehing :)
<14> this ****s, the old network director used to take care of EOM/EOY tapes, when he left no one else did it
<14> so we missed a few eom tapes and last years OE
<14> er eoy
<0> rs.fields.count is suggested
<9> #asp could probably tell you. I do believe that an ADODB.Recordset has a Fields collection
<4> Hey Halo, do youknow anything about SQL 2K Full Text Search?
<9> Nope
<4> k
<0> worked
<14> careful with that full text stuff, it can bring your server to a crawl
<4> yeah im reading about it now
<4> i mean i dont know if i need it really
<13> http://kalorin.com/stuff/images/heeyy.jpg
<12> Halo_Four: wouldn't a bitmask search on the phone number as an integer be just as fast (if the phone number col was indexed)?
<12> if i want to find all the phone numbers in my database in the 312 areacode...
<9> Range search would be fast.
<9> WHERE PhoneNumber BETWEEN 3120000000 AND 3129999999
<9> Performing any operation on the column would negate the index.
<15> :-)
<16> http://www.hm2k.org/news/1137968795.html
<16> that startkeylogger "bug" is funny stuff
Return to
#sql
or
Go to some related
logs:
#red
REF THAT SEND BECKAM OFF
#visualbasic
www.seyhan.com
#beginner
#worldcup
#computers
#beginner
#politics
#politics
|
|
