Author |
Topic |
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-03-29 : 03:29:09
|
I hope this query is in the right forum but I am not getting answer I want and need to. Please tell me the answer to this query immediately please or I miss deadline please.SELECT Home_Network_Attached_Storage_Device from ShopWHERE Gigabit_Ethernet = 'Desirable'AND Support_RAID = 'Nice especially if SATA'AND UPnP_media_server = 'Essential'AND iTUNES = 'Maybe'AND Useable_from_Linux = 'possible'AND Cost < £200 or Cost <£150AND Capacity > LOTSI get more than one answer and only want one answer please tell me answersteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-29 : 03:30:32
|
use TOP 1 with ORDER BY  KH |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-29 : 03:50:28
|
quote: Originally posted by Peso DISTINCT?Peter LarssonHelsingborg, Sweden
Should useTOP 1 ORDER BY <your criteria>DISTINCT will still return more than 1 rows. The OP only wants ONE ANSWER. KH |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 03:58:59
|
And with this, he has gotten 4!I just realized he was pulling our legs since he know this after more than 1540 posts.Therefore I deleted my answer because "I want only one answer"...I think he needed your link only.Now when I and my girfriend buy our house in May, we are getting the same SC101 with TURBO (1 gig/s transfer).That's why I originally posted DISTINCT, since SC101 comes with 100 meg/s transfer too.http://www.netgear.com/Products/Storage/NetworkStorage/SC101T.aspxPeter LarssonHelsingborg, Sweden |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 04:05:00
|
quote: Originally posted by khtan i use this http://www.netgear.com/Products/Storage/NetworkStorage/SC101.aspx.
How long have you been using this?Any comments, good or bad, about it?Peter LarssonHelsingborg, Sweden |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-29 : 04:14:02
|
"How long have you been using this?"1.5 - 2 year"Any comments, good or bad, about it?"GOOD- you can put your own HD in there so the capacity is up to you.- Up to 2 HD- Initial firmware version not so stable but the current version is fine. - Does not encounter any issue with the current firmware version.- can mirror partition on same physical disk and as well as to another physical diskBAD- Not as fast as i would expect it to be. But maybe it is because I set it to mirroring- Storage format is not standard. Propitiatory format. Risk of not able to access the HD content when device is down.- 100Mbps only. Not giga KH |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-29 : 04:18:22
|
Didn't see your prev post. The 101T looks better. the SC101 looks like a toaster KH |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 04:23:18
|
So you can use either RAID 0 (stripe) or 1 (mirroring)?Or only mirroring?Read the fine-print Only supports mirroring.Peter LarssonHelsingborg, Sweden |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-29 : 04:26:46
|
Can't remember. Not sure stripe is supported or not. I only use mirroring. kiasu  KH |
 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-03-29 : 04:40:03
|
OOH must admit I hadn't seen the T it does look a lot better - I was looking at a LaCie [url]http://www.lacie.com/uk/products/product.htm?pid=10844[/url] which seems nice.Having said that I mostly have netgear kit at home and find it does pretty much everything I need.Khtan do the drives need to be matched?Steve-----------Don't worry head. The computer will do all the thinking from now on. |
 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 05:14:43
|
quote: The SC101 is practically maintenance-free. It uses a SAN File System (SFS) that does not need you to defragment it, or to use other Windows utilities such as chkdsk. For the SC101's own defragmenter to work properly — and as with any hard disk, to avoid poor performance — leave 10% free space on each disk or drive. (Remember, the SC101 uses the word drive to mean what is usually called a disk partition.)
Peter LarssonHelsingborg, Sweden |
 |
|
|