Jump to content
Search In
  • More options...
Find results that contain...
Find results in...


  • Content Count

  • Joined

  • Last visited


This user doesn't have any awards


About adman29

  • Title

Contact Methods

  • Steam
  • Twitter

Profile Information

  • Location
    Looking for a Case now (Send recommendations)
  • Gender
  • Occupation
    Operations Technician


  • CPU
  • Motherboard
    ASRock Z97M Pro4
  • RAM
    16 Gigs Corsair Vengeance DDR3 (In red, of course)
  • GPU
    EVGA GTX1080 Ti
  • Case
    I found it on the side of the road. I dunno, NZXT something
  • Storage
    120 Gig Samsung SSD, 1TB Seagate, 1TB Samsung (HDD)
  • PSU
    Corsair TX750
  • Display(s)
    Original Apple Cinema Display
  • Keyboard
    Corsair K70

Recent Profile Visitors

1,172 profile views
  1. @Abdullah Bhutta yeah sure take a shot at it. Something similar, try and keep it under 2K USD
  2. 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/ obtai
  3. My girlfriend is using another computer, however not using anything taxing, and then my laptop at the moment, neither on ethernet
  4. Hey all, I've been having an odd issue with my lan connection, over an Intel I218-V. Whenever I ping something like 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?
  5. 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 l
  6. 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
  7. 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
  8. Have the same problem with mine but yeah I feel the same way
  9. 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.
  10. @Exprima the weird little ARM Chip based surface, can it run full windows apps, or are we going through another Surface RT period?
  11. 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 a