How do I set up Windows 2003 Server as a replacement for Windows XP for use on a typical desktop computer?

Question

Windows Server

As you know, Windows XP is still popular among the people, despite the termination of technical support - sufficient functionality, weaker requirements for hardware (and there is still enough of it, weak, especially in budget organizations). Windows 2003 Server, as it turned out, is basically the same (if you don't use specifics), but it works, all other things being equal, somewhat faster, although not without problems.
In search of a solution to these problems, I found only this article . No words, a useful article, but there are no answers to many questions. Let's say that the usual free antiviruses and Google Chrome refused to be installed on Windows 2003 Server. Office suites Microsoft Office 2007 and Chinese WPS also refused to be installed, only LibreOffice 5.1 got up normally.
Can someone suggest how to get around this?

Answer 1

These systems serve different purposes. You don't hammer nails with a microscope. If you only need to surf the Internet and work in the office, install Linux with lightweight graphics (for example, XFCE)

Answer 2

One question here only suggests itself, but what for?!?! That article dates back to 2005.

Answer 3

Everything is slow because you enumerate 2 tables in a row, getting the full product of matrices in the amount of 1kk * 400k = 400kkk records.
It's like writing "from a, b".
Correct request

UPDATE TABLE sp_germany AS a 
JOIN TABLE sp_germany_small  AS b ON b.product_artikul = a.product_artikul
SET a.product_price = b.product_price

Well, indexes on the product_artikul field should be in both tables.

Answer 4

try to wrap it all in a transaction - at least the commit will be 1, not 400K.

START TRANSACTION;
SET AUTOCOMMIT=0;
UPDATE sp_germany as a, sp_germany_small as b
SET a.product_price = b.product_price
WHERE b.product_artikul = a.product_artikul;
COMMIT;
SET AUTOCOMMIT=1;