URGENT QUERY! Needs immediate attention

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

URGENT QUERY! Needs immediate attention

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

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.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-29 : 03:51:47

i use this http://www.netgear.com/Products/Storage/NetworkStorage/SC101.aspx.

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

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

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

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

Posted - 2007-03-29 : 05:09:32

i remember it does not have to be matched. But can't find reference. Maybe you can refer to http://kbserver.netgear.com/products/sc101.asp This is for SC101.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-29 : 05:10:02

SC101T doesn't seem to be available yet in stores.

CASE ONLY
http://www.tigerdirect.com/applications/SearchTools/item-details.asp?EdpNo=1647989&CatId=2670

2x500 GIG
http://www.tigerdirect.com/applications/SearchTools/item-details.asp?EdpNo=2380071&CatId=2671

2x750 GIG
http://www.tigerdirect.com/applications/SearchTools/item-details.asp?EdpNo=2465519&CatId=2671

Peter Larsson
Helsingborg, Sweden

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources