The Micro-ATX DG41RQ should fit into all ATX cases, but its smaller size allows you to downsize your system build as a whole. DDR2 memory is exceptionally out of date, and considering how cheap DDR3 RAM is, using a motherboard with only DDR2 compatibility in a modern system build would be a very bad idea.
It uses the aging DDR2 memory type, with maximum speeds of up to 800 MHz, and 2 DDR2 slots allowing for a maximum total of 8 GB RAM. Any compatible Intel CPU will have the same socket entry.
The DG41RQ uses the Intel LGA 775/ Socket T CPU socket.