Search results

  1. E

    Best way to aggregate/group JSON data?

    Hey, all, Let's say I have some locally hosted/downloaded JSON data like the following: user: { "firstName": "John", "lastName": "Smith", "age": 25, "address": { "streetAddress": "21 2nd Street", "city": "New York", "state"...
  2. E

    SQL: Inner Joins inside Outer Joins

    Greetings, I'm a bit surprised that these two queries give different results: SELECT a.number, a.name , b.* FROM Atable a LEFT OUTER JOIN Btable b JOIN Ctable c ON c.number = b.number ON b.number = a.number ORDER BY a.number; SELECT a.number, a.name , b.* FROM Atable a LEFT...
  3. E

    T-SQL: Deterministic RAND(seed) in UDFs

    Greetings, Okay, for you fellow SQL geeks: SQL (or, at least, Microsoft/T-SQL) does not allow you to use rand() in a user-defined function, at least as of 2008 R2. It's non-deterministic, I get it, no problem. Here's the thing, though: if I pass a seed, such as rand(123456), it's no...
  4. E

    HTIB Under $300: HT-S3500?

    Greetings, For Christmas this year, my wife and I are splurging (yes, I know-- money is tight) and upgrading from our TV's internal speakers to some sort of surround sound setup. We have around $300 to play with. We're not very picky-- don't need wireless speakers/subwoofer, smartphone...
  5. E

    Bizarre SQL Union/All Result

    Greetings, So, for work, I have two queries, A and B. When run by itself, A returns 1 row (with 1 varchar column) and B returns 1984 rows (with 1 varchar column). Neither A nor B, by themselves, return any null results. However, when I run the following: A UNION ALL B 17 of the...
  6. E

    GV for Personal Num on Work Phone

    Greetings, I'm receiving a promotion (whoohoo!) and my work will provide an Android phone for me. I'm allowed to use the phone for personal calls/etc, but if I port my number over, they will own the number and I may not get it back if I leave. I don't have a smartphone yet (I actually use...
  7. E

    Android or WP7 Without Voice/Data?

    Greetings, If I were to purchase an unlocked Android or Windows Phone 7 (I'd prefer the WP7, but if it'll work on Android and not on WP7, that's good to know), could I use it for music and apps over WiFi without a voice or data plan? Basically, could I use an unlocked Android or WP7 as an MP3...
  8. E

    Newegg Fly Infestation!

    Greetings, I'm not sure where I should post this, so hopefully off topic will work. The tl;dr is at the bottom, but I'd appreciate it if you'd stick around for the story. I ordered a bunch of hardware for an HTPC I was building from Newegg, and got it in on Thursday of last week. It was one...
  9. E

    Learning OO Programming Via C#?

    Greetings, In my daily job, I use SQL (which is obviously not an object oriented language) on a daily basis, and enjoy it quite a bit. However, for quite some time now, I've wanted to learn about object oriented programming-- it seems quite powerful, and it seems to be where to go for...
  10. E

    Windows 7 Scanner Compression: LZW to G3/G4

    Greetings, So, I work in IT, and a department had a PC running Windows XP that would scan documents as TIFFs with G4 compression. The PC was upgraded to Windows 7, and now it scans documents with LZW compression. Unfortunately, a proprietary script/executable we run needs the TIFFs to be...
  11. E

    HTPC Plans: Upgrading Over Time

    Greetings, I have a 50" Panasonic G25, and am looking to build an HTPC after our old one died. So far, I have a new 430w Corsair PSU, 4GB of 1333 DDR3, a Lenovo mouse/keyboard wireless doohickey, a hard drive, a DVD Drive, a Radeon 4350 for its HDMI output, and a copy of Windows 7. I also It...
  12. E

    ASRock CORE 100HT-BD V2

    Hey there, So, after reading the review linked below, I'm considering picking this HTPC up: http://www.legitreviews.com/article/1568/1/ Seems like really good bang for buck at $580. We have a 50" Plasma (Panasonic G25), and our old HTPC bit the dust and isn't worth the money I'd spend...
  13. E

    BIOS Messages, Etc

    Greetings, So, my last X58 motherboard had some issues, and I received another one through RMA. Ever since I received the second one, I've had all sorts of problems, several of which are still occurring. I've never done any overclocking. I have an i7 920, 6GB of Corsair DDR3, and two EVGA...
  14. E

    Help: Corrupted Wireless?

    Greetings, My PC specs are in my signature. Last night, my PC (Windows 7 x64) worked without a problem. It shut down cleanly. This morning, when I turned on my PC after BIOS/POST but before the OS, I was taken to a black screen telling me to run CHKDSK. I couldn't get into the OS, but I was...
  15. E

    Purchased 4650 with 400W PSU...

    Greetings, I received an out-of-use PC as a gift, and am planning on turning it into an HTPC while spending as little cash as possible. Here are the relevant specs: MoBo: Asus P5N-E RAM: 1 GB DDR2 (one stick; I hope to add another, later) CPU: e8400 2x IDE DVD Reader/Writer 3x Case Fans 1x...
  16. E

    Low-Budget HTPC GPU

    Greetings, I have a PC with an e8400, 1GB of RAM, and a fairly poor PSU. I have installed Windows 7 on it, and am looking to turn it into our home's HTPC. All it will need to do is play Blu-Rays and locally stored media on our 50" Panasonic Viera G25. It does not need to be able to game, show...
  17. E

    EVGA x58 and P55: Reboot Before Booting

    Greetings, I recently built my wife a PC, and used an EVGA P55 motherboard for it. My motherboard-- an EVGA x58 SLI-- had recently died (of unknown causes), and its replacement had just arrived. Windows 7 installed just fine on her computer, and my PC recognized the new motherboard and...
  18. E

    Dell Vostro 1500 Won't Boot

    Greetings, I've been allowing my wife to use my laptop-- a Dell Vostro 1500-- and now it won't boot. She maintains that nothing unusual happened; she was playing Dark Messiah of Might and Magic (yes, I have an awesome wife) right before shutting it down, and the game performed fine. Here's...
  19. E

    Issues Replacing Motherboard?

    Greetings, My EVGA x58 Motherboard recently died. It was covered under warranty, and I should have its replacement (same model) here soon. I will obviously be cleaning thermal paste off the CPU/heatsink, but aside from that, will I need to do anything special? Will I need to repair or...
  20. E

    GTX 480 or GTX 460 1GB SLI?

    Greetings, I have an x58 motherboard and an i7 920 processor. My PSU is a Corsair 750TX, and I have 6GB of RAM. I will be giving my GTX 285 to my wife, and will be purchasing a new GPU (or GPUs) for myself. EDIT: My resolution is 1920x1200. My motherboard is an EVGA, so is fully SLI 16x...
  21. E

    Considering a Zune HD... or iPod Touch... What to Get?

    Greetings, So, I currently have an old iPod Mini from 2004-- the thing has a battery life of about 4 hours now, and is pretty beat up; I'm in the market for a new audio/video player. I don't have a specific budget, per se, but I believe that the price/value ratio is really important, and I...
  22. E

    Windows 7 for $29.99 for Students through Microsoft!

    Greetings, Check out: http://www.win741.com/ Seems to be legally hosted by Microsoft and allows individuals who are students to purchase Windows 7 for $29.99. I'm going to give it a shot and report back later. Have a great day! Let me know what you think.
  23. E

    W7 x64: Complete Burning/Ripping Solution

    Greetings, I've recently been approved for "early access" (or whatever it ought to be called) for Windows 7 x64 Professional through MSDNAA, and have downloaded, installed, and activated it. I've been using the 7100 RC build for some time, and always had numerous problems with DVD burning...
  24. E

    EVGA x58: Automatic Boot Order Menu

    Greetings, all, So, I successfully installed Windows 7 on my PC and want it to dualboot with XP; unfortunately, I did so on a physically different SATA hard drive, which I've discovered makes it nearly impossible to control with an OS-based boot menu. However, I have discovered that, by...
  25. E

    I7 HSU Options

    Hello, everyone, I've decided to upgrade my stock heatsink for my i7 920, and have been researching options. I need something that is easily installable, isn't going to run too expensive, and isn't massive. I've been looking at the Akasa Nero, but have read pretty mixed reviews on it...
  26. E

    i7 920: ~80C Stock Idle?!?!

    So, question, guys... My EVGA x58 motherboard's LED says that my CPU is idling at about 69-70C, which seems a bit high. I downloaded Core Temp and ran it... Core 1: 79 Core 2: 77 Core 3: 84 Core 4: 84 So, I haven't done any overclocking. I'm quite certain that the CPU Fan (stock) is...
  27. E

    New i7 EVGA x58: USB Errors = Immediate Shut Off?

    Greetings, all, So, my new x58 motherboard with an i7 has been working fine for several days. However, as of yesterday, it shuts itself off after about 4 minutes. I tried entering the screen where one can pick between Safe Mode/Safe Mode with Networking/Etc. from the f8 key, and it even shut...
  28. E

    Effect of GTX 275 on price of GTX 285?

    Greetings, all! I'm going to purchase an EVGA GTX 285, but have a question or two about timing. 1. There's been some controversy about whether the GTX 275 will be released tomorrow... think that's pretty reasonable? 2. Do you estimate that the price of the GTX 275 will lower the price of...
  29. E

    New x58 Motherboard: Destination Host Unreachable

    Greetings, all, So, with the recent pan-searing of my old S939 Motherboard, I plopped an i7 920, EVGA x58, and 6 gigs of RAM into my system (I'll upgrade to x64 Vista pretty soon). Removed all chipset/network/display/etc. drivers, repaired the OS, and installed the new drivers. Everything...
  30. E

    GTX 285 SLI with Corsair 750TX

    Greetings, all, So, I'd like to know if a Corsair 750TX would be able to power two GTX 285's running in SLI. I've found a bunch of different-- and largely contradictory-- answers online, and am not sure whether this PSU could support it. My PC is an i7 rig, and has only a single hard...
  31. E

    Socket 939 to i7: Same Hard Drive?

    Greetings, all, So, I've been running a Socket 939 setup for about 3 years, and the motherboard was recently fried due to a crappy PSU. It's definitely gone; no hope of it returning. If I purchase a new setup-- something way faster, such as an i7/x58/DDR3-- I've read on several sites that...
  32. E

    CPU, No Overclocking, Buying in Next 4 Months

    Hey, all! So, my current PC is extremely outdated (ie, Athlon 3800x2), and I'm getting ready to purchase a new CPU/motherboard/RAM (still on ddr1), etcetera. I will not be doing any overclocking with it when I get it; I'm busy with work and classes, and want to use my computer for gaming, not...
  33. E

    Socket 939 bottlenecking GTX 280 at 1920x1200?

    Greetings, all, I'd like to upgrade the gaming capabilities of my PC, but can't afford a new system at the moment, as I'm saving up for a wedding. However, I'd definitely be willing to purchase a new power supply and graphics card. Here are my current specs (that I believe would be...
  34. E

    Limits on Upgradability?

    Greetings, all! So, I have a new 24" monitor, and want a new graphics card for 1920x1200 gaming. However, my current PSU couldn't handle much of an upgrade, so I'll need a new one of those, too. I'm pretty familiar with the standards by which I should consider new PSUs; my question is this...
  35. E

    Wii on HP LP2475W

    Greetings, all, So, I have an HP LP2475w on the way: http://h10010.www1.hp.com/wwpc...70-444767-3648442.html I'm going to use it primarily as a PC monitor, but I'd like to have my Wii set up to it as well. The monitor has all sorts of inputs...
  36. E

    HP LP2475w: Gaming Lag?

    Greetings, I'm considering purchasing an HP LP2475w 24" monitor. I've read very mixed reviews concerning whether or not it is problematic for gameplay; a large majority seem to say there are no negative results, but certain forceful individuals and review sites imply that the monitor would...
  37. E

    Creative FATAL1TY 3.5mm

    Greetings, all! So, I'm looking for a new headset for gaming, and I've done a bit of browsing. After looking at models of different prices and qualities, the Creative FATAL1TY 3.5mm ($50 at Newegg) seems pretty decent-- it's received stellar reviews not only at Newegg, but elsewhere as well...
  38. E

    Netflix Watch Instantly

    Greetings, all! So, I'm interested in the Watch Instantly feature for Netflix (with regard to TV Shows), and have 2 quick questions: 1. Can anyone tell me if Psych and Monk are available as Watch Instantly options? The specific DVD pages don't indicate whether they are or not, as I do not...
  39. E

    24" LCD Monitor

    Greetings, all! So, I'm looking to purchase a new monitor. My new one, a 19" Fuji Plus LCD, has served me well for several years. However, I love PC gaming, and have recently been using my PC as my media center to watch movies on with friends. I'd like to upgrade it to something that would...
  40. E

    0 Frames Per Second?

    Greetings, all! So, I was reading some reviews of the new R700 on a few sites, and noticed that they said some graphics cards performed at 0 Frames Per Second at certain high resolutions. I was wondering-- how is that possible? I can understand something very close to 0-- say, 0.0075 frames...