| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> read up on them on google
<1> I'll read it up sometime
<1> thanks
<0> many great sites out there
<0> and if u plan on doing any kind of db.. u should understand them
<1> true
<2> SicLuDe: OK, thanks.
<0> Aragorn16: you should rethink your design if you need text as your primary key
<0> you understand that text can be upto 2gb
<2> Icewolf-: It took me many many months to fully understand all the different types of JOINs and how NULL uses them, so don't feel bad if you don't get it right away.
<0> and that each text column is stored on a disk separately from the table
<2> SicLuDe: It's not a permanent solution.
<1> Aragorn16: ok thanks, I was being afraid I was just way too dumb ;o)
<0> so for each time u want to compare, it will have to go find that record on the disk and we arent even talking about comparing upto 2 gb of text
<2> I'm doing this to capture matching items from two different RDBMSs that cannot be matched any other way.
<0> have you tried varchar?
<0> nvarchar?
<2> I suppose I could [should] have done that.
<2> I didn't think it would make that much of a difference.
<2> I could probably still change it.
<0> possibly even hashing the two text? (although this is not the best solution but i dont know what ur requirements are)
<0> it will make a huge diff
<0> varchar is stored on teh table.. for text, the table stores a reference on the disk in the table
<0> even varchar is not ur best option but certainly better than text
<2> It's only about 15k-20k records in A matching to 30k in B.
<2> Will varchar(30) do?
<0> i dont know
<0> its ur data
<2> As for hashing, I'm not quite sure what you mean by that.
<2> I've never created a hash table before.
<0> dont worry about that
<0> i cant tell u if 30 will do.. i dont have acecss to ur data
<2> Would hashing be creating a linker table to match the two tables together?
<2> HASH(id int, id_a text, id_b text)?
<0> dude dont worry about hashing
<2> OK, OK..
<2> Well, let's see if indexing varchar(30) helps enough...
<3> just to be aware, you can store up to 7000 bytes of TEXT data in-row, if certain conditions are met (not commenting on the design, just clearing up the use of TEXT in SQL Server 2000)
<3> You cannot, however, create Primary Keys on it
<2> But you can on varchar(x).
<0> TheGamble: heh i was staying away from the exceptions
<0> and going with teh worst case
<3> I realize that; I only wanted to add to the "each text column is stored on a disk separately..." comment that you made.
<0> agreed
<4> Does anyone have any suggestions regarding use of uniqueidentifier vs int w/ auto-increment in SQL Server 2005?
<0> strategy: i would go with int
<4> for portability?
<0> nah just less storage
<0> :)
<0> easier to look at
<0> uniqueidentifier is acutally a guid i think
<0> but yes portablily is a factor too... dont know if guids are supported on all systems
<4> <Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>
<4> Just saw that on a Forum, thought I'd share.
<0> lol
<0> i woudlnt say its bad practice to use guids
<0> to me its a matter of preference i guess
<4> every other field in my DB is an auto-increment int field, so I'll stick with that. :) thanks.
<0> anyone know wehre the client tools for mssql 2005 are?
<0> on m$ site i mean
<4> certainly makes adding sample data eaiser.
<4> SicLuDe: I just downloaded 'em the other day, let me look.
<0> well with guids, you can just set the default to NewID()
<0> and that will make adding just as simple
<4> <Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>
<4> doh, wrong pages.
<4> paste.
<4> http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en
<4> Microsoft SQL Server Management Studio Express
<0> thanks
<4> np.
<5> or did i just not install it?
<5> i'm using that express client, but i would think the enterprise edition would come with somethig
<4> Is there no Import/Export Wizard w/ SQL Server 2005 Express?
<5> yes, there is
<4> I'm guessing it's not through the Mgmt Studio.
<5> they're only available on whole databases i think
<5> yes it should be
<6> 2005 Express doesn't ship with DTS/SSIS
<4> k...
<4> can you download SSIS separately?
<6> No
<5> i thought he was talking about the management studio express
<5> heheh
<2> SicLuDe: Thanks a lot, it worked without a hitch (15k rows in 0.67 secs).
<2> :)
<2> I didn't even have to index it...
<7> management for sql express is in beta
<7> but is available
<4> If I have a BULK INSERT statement, how do I tell SQL to create the primary key field (int, auto-increment) automatically for each row?
<0> strategy: just dont include the column thats automatically incremented in ur insert
<5> SicLuDe: i think that varies per dbase
<5> since it'll work in mssql, but for mysql and postgres the amount of rows must be satified
<5> so you have to use (column, column) VALUES when inserting
<0> "amount of rows must be satisfied" ?
<8> that's cool shiz
<8> so then mysql and postres don't support IDENTINTY
<0> i dont get it
<0> what does amount of rows must be satisfied mean?
<8> it means if you aren't willing to satisfy sql server, its not going to add your rows
<8> didn't we discuss this earlier in a different channel
<5> ...
<5> heheh
<9> :)
<0> Phyx-: nah im serious... i dont get what u mean
<5> SicLuDe: 3 rows, id, name, test id is identity in mssql INSERT INTO table VALUES (nam, test) works, in postgre it fails becauze the table has 3 columns, it needs INSERT INTO table (name, test) VALUES (nam, test)
<0> ok...
<0> whats your point?
<0> i dont think that actually works for mssql
<0> i think you need the same format as the last one for mssql also
<10> Phyx- are you confusing the term "row" with "column"?
<0> when i say dont provide the colunm, that means take it out of hte list of columns and the list of values
<5> tenfour: yes, i 16:41:55 < Phyx-> since it'll work in mssql, but for mysql and postgres the amount of rows must be satified
<5> should be column
<5> heheh
<0> mssql it must be satisfied afaik
<5> not in mine,
<8> what exactly is your error?
<0> never tried inserting data like that
<0> MuteThis: no errors, we just talking
<8> no error :()
<4> Is there a way when using ORDER BY to put NULLs last?
<10> order by IsNull(field) desc, field
<4> n/m, got it.
<4> thanks.
<11> If my SQL script have 1 MB will work ?
<11> what is the maxim size of an SQL script ?
<12> i have scripts bigger then that
<12> its just statements
<11> thank CoJoNEsXx
<0> im bored... again
<13> I like the topic heh
<12> fitting around here
<0> um...
<0> whats a google?
<0> is that like another one of those dating sites?
<14> hi...i'm having a problem with SQL 2005 express. I'm writing a simple c# program to create a database
<14> but I'm getting an error provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
<0> eljainc: um.. why not use the db tools to create the datbase?
<14> is dbTools a cl***/library?
<0> sql server management studios
<0> creating a database shoudl be a one time thing
<0> u should not have to write a program to do it
<14> I am just learning it though...how to create a database
<0> ?
<14> how to program with C# and SQL
<0> in a real application, you will not use c# to create a db unless you had some weird app
Return to
#sql
or
Go to some related
logs:
candy diskonkey
hard disk diagnostic tool mhv2100 fujitsu
#goal
#heroin
#linuxhelp
#politics
#red
#nhl
#delphi
memtest86 gui
|
|