How many CPU cores can SQL Server use?

Ever wondered how many CPU cores SQL Server is actually using? Here's a simple query that will display this information.

SQL Server and CPU core usage How many CPU cores can SQL Server support should be a simple question, you might think. However, judging by how often this question is asked on the SQL Server forums its clear that there is a lot of confusion about exactly how many CPUs a particular edition of SQL […]