| 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 Shop
WHERE 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 <£150
AND Capacity > LOTS
I get more than one answer and only want one answer please tell me answer
steve
-----------
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 Larsson
Helsingborg, Sweden
Should use
TOP 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.aspx
Peter Larsson
Helsingborg, 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 Larsson
Helsingborg, 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 disk
BAD
- 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 Larsson
Helsingborg, 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 Larsson
Helsingborg, Sweden |
|
|
|
|
URGENT QUERY! Needs immediate attention