| Author |
Topic |
|
khennessy86
Starting Member
5 Posts |
 Posted - 2006-02-16 : 07:28:36
|
| hey is sql server able to handle complex data compared to oracle ,mysql or access |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-16 : 07:49:57
|
| Hi khennessy86, Welcome to SQL Team!I don't know if its just me being thick! but what do you mean by "complex data" ?Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-16 : 07:54:02
|
| Define the complex dataMadhivananFailing to plan is Planning to fail |
|
|
|
khennessy86
Starting Member
5 Posts |
Posted - 2006-02-16 : 10:39:59
|
| what i meant by complex data was video clips , music clips that sort of thing |
|
|
|
Kristen
Test
22859 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-02-16 : 14:59:01
|
quote:
Originally posted by khennessy86
what i meant by complex data was video clips , music clips that sort of thing
I believe Microsoft Sharepoint can store all those types of data, and Sharepoint stores all of it's data in a SQL Server database.CODO ERGO SUM |
|
|
|
jhermiz
3564 Posts |
Posted - 2006-02-16 : 15:48:57
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by khennessy86
what i meant by complex data was video clips , music clips that sort of thing
I believe Microsoft Sharepoint can store all those types of data, and Sharepoint stores all of it's data in a SQL Server database.CODO ERGO SUM
Sure does, the issue is finding that data is difficult. Table names are pretty cryptic or unusual. Fields have abnormal names like:varchar1, varchar2, varchar3...etc :)
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-16 : 15:52:59
|
| I once had to support a database that had column names like Thing1, Thing2, ... It was a COTS package. I believe they did it so that their customers couldn't figure out their schema. It must have been hard to develop on it though.Tara Kizeraka tduggan |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-02-16 : 16:08:19
|
quote:
Originally posted by jhermiz...Sure does, the issue is finding that data is difficult. Table names are pretty cryptic or unusual. Fields have abnormal names like:varchar1, varchar2, varchar3...etc :)...
I agree. I was just making the point that it can be done.If you are using Sharepoint, I don't think it's a good idea to try to hit the database directly to get data. If you can't get what you need through the Sharepoint interface, it isn't the tool you need. Even if you can figure out where data is, that doesn't mean that's where it will be after the next release.CODO ERGO SUM |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-02-17 : 08:35:03
|
| Trying to make the schema hard to figure out is the most bizarre notion invented by coders. If you spell it out for more customers they couldn't select their top 10 customers from the database. And if they want to get to the data, they will certainly find a way. Sounds like programmers at Microsoft and the developers of the application that Tara had to support both coded for and probably had great job security. It's not hard enough to maintain other peoples code as it is, why not add the challenge of select thing1, thing2, thing3, thing5 from bigthing inner join otherthing on bigthing.thing1 = otherthing.something where bigthing.thing122 = @thingvariable order by thing3, thing5. Wooo hoo. I got the list of things I needed. Probably the same coders behind teh eBay "IT" adds. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-17 : 13:16:40
|
druer, you left out thing4  Kristen |
|
|
|
|
is sql server able to handle complex data