adman29

@Abdullah Bhutta yeah sure take a shot at it. Something similar, try and keep it under 2K USD

Budget (including currency): Idk, 2500 USD tops Country: United States Games, programs or workloads that it will be used for: Mainly Number Crunching and doing work on large datasets. Other details (existing parts lists, whether any peripherals are needed, what you're upgrading from, when you're going to buy, what resolution and refresh rate you want to play at, etc): Hi all, I'm back in Education IT. I have a new professor coming in who's going to be doing a lot of coding and working with large datasets for his research. Below is the build he would like me to make/ obtain. Does anyone else find this like maybe a little weird for the use case? And if so, what would you recommend different? It's been a little while since I have built a computer, but isn't AMD like top dog on working on large workloads right now? I know he's going to be using a crap ton of MatLab if that matters Motherboard-ASUS Z490-P Processor-Intel i7 10700K 8/16 core 3.8/5.1 GHz RAM-Patriot 2x16GB DDR4 3200 MHz HDD-Seagate Barracuda 2TB 7200 RPM PSU-Corsair 650W GPU-Nvidia GTX 1650 4GB GDDR6 Keyboard/Mouse-Logitech MK345 Monitor-Acer 24 inch 1080p CPU liquid cooler ASUS internal CD drive Case-Cougar MX330 Fans-120 mm (3 pack) SSD-Samsung 860 EVO 1TB M.2 DP to HDMI cable 6 ft for displays Ethernet cable 10 ft

My girlfriend is using another computer, however not using anything taxing, and then my laptop at the moment, neither on ethernet

Hey all, I've been having an odd issue with my lan connection, over an Intel I218-V. Whenever I ping something like 1.1.1.1 it'll fail out twice, then I'll get a 2000ms+ ping, and then a 14ms ping Whenever I ping the router, it'll give me a 1500ms+ ping, then a <1ms ping twice and then whenever I ping something like google.com it'll only resolve under IPV6, and give me 2 time outs and then a tiny ping to high ping. Any ideas? If it's my chipset dying, does anyone have recommendations for an Ethernet pci card?

DO YOU WANT TO BE A BETTER DATA CENTER TECHNICIAN? TAKE THE DCCA EXAM Well here's how. This is the guide becoming a better Data Center Technician. I am in no way guaranteeing that you're gonna pass. This is just how I did it, and it might work for other people 1. Register For Schneider Energy University (It's Free) Go to this website https://www.schneideruniversities.com/energy-university/ Create you an account Register for the "Data Center Certified Associate" course 2. Complete the Coursework To complete the coursework, there's a total of 16 lessons. There's 2 intro lessons to figure out how to use the course, and 14 actual lessons of material. In the actual lessons you'll cover a decent array of material -- basically anything that a datacenter would use to operate. This includes, but is not limited to: Cooling Racks Fire Protection & Safety Physical Security How electricity and electrical systems work Take all of the lessons Do this by: Watching the slide show & listening to the audio track (Notes are arguably not needed) Taking the Quiz These are usually ~11 questions, all pretty easy. It's nothing too difficult, just what was gone over in the slideshow. Usually the question's answer will be directly stated in the slideshow. Filling out the feedback form You can be as detailed as you feel like being. Download the Course Transcript at the end. I have included a copy of the course transcript with this post as an example. 3. Take the Test First, register for the test This is gonna cost you $250.00 USD And after buying it you have 30 days to take it Once you start you have 120 minutes to finish. This does not stop There's also 100 Questions Also do not open the slides; your test stops and you cannot restart it. Second, Get all your notes ready. Turns out that 90% of the test material is in the Course Transcript. If you've ever taken a college course, you'll know how to Ctrl-F your way through most of those questions. The problem is, at least for me, there were 10-ish questions not in the transcript First one was in a WhitePaper, but also possibly on the slides -- It's basically a diagram with arrows and racks that differentiates Rack, Row, and Room cooling. The others were basically all around electrical distortions -- again, they were probably on the slides, but I had no way of checking. If you take this test and feel like more needs to be added, please feel free to add it below. Unfortunately, I couldn't find too much about it online, but my job wanted us to get this certification. Let me know if you have any questions! DCCA Course Transcript.pdf

O365 has addons? That're paid? Wtf

Okay, I figured it out, sorry for the quick turnaround, but if anyone needs the info for future reference: Select P.ProductModelID, P.Name, CAST(((P.ListPrice - P.StandardCost)/P.StandardCost) AS DECIMAL(18,2)) AS ProfitMargin From Production.Product P Left JOIN Production.ProductSubcategory PS ON P.ProductSubcategoryID = PS.ProductSubcategoryID Right Join Production.ProductCategory PC ON PC.ProductCategoryID = PS.ProductCategoryID Where PC.ProductCategoryID = 1 ORDER BY ProfitMargin DESC

Hey Y'all, I've been working on a SQL Project and I missed the lesson on Cast and Convert Would anyone know how to Cast a calculated field into a decimal that has only 2 decimal places? My current code is basically: SELECT P.ProductID, P.Name, (P.ListPrice-P.StandardPrice)/P.StandardPrice AS Profit Margin FROM Produciton.Product P //A whole bunch of Joins down here) Lemme know if you have questions

Have the same problem with mine but yeah I feel the same way

You work for Tierpoint? I tried it with my Sony XA2, and no dice. You can use the mouse and keyboard connected to the dock, and charge off of it, but that's pretty neat tbh. Probably won't damage the battery, but if you're scared don't risk it.

@Exprima the weird little ARM Chip based surface, can it run full windows apps, or are we going through another Surface RT period?

Ah good idea Thank you

Hi all, I basically need to have two case statements outputting to two columns in Transact SQL. I have the first half here: USE AdventureWorks2017 Select CASE WHEN PersonType = 'SC' then 'Store Contact' WHEN PersonType = 'IN' then 'Individual (retail) Customer' WHEN PersonType = 'SP' then 'Sales Person' WHEN PersonType = 'EM' then 'Employee (non-sales)' WHEN PersonType = 'VC' then 'Vendor Contact' WHEN PersonType = 'GC' then 'General Contact' ELSE '' END AS PersonTypeEvaluated From Person.Person I need to have it basically concatenate FirstName MiddleName and LastName in the second Case statement.

what's your short list?

Hi all, Does anyone have some newer indie Rap that's any good? I love MF Doom & most of his work, along with Aesop, Mos Def, etc. but I've been noticing they've not put out anything recently. Any ideas based off of that?