Is it right that:
For SQL Server 2008 Enterprise Edition, the max memory limit is Operating system maximum while for SQL Server 2008 R2 Enterprise Edition its 2TB (OS max is for Datacenter Edition).
In the same way for SQL Server 2008 EE, the max CPU limit is Operating system maximum while for SQL Server 2008 R2 EE its 8 (OS max is for Datacenter Edition).
Yes, your statements appear correct. If you need to compare more details, here are the Microsoft sites:
Edition comparison for SQL Server 2008 R2:
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server.
In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Two types of users will appreciate AOMEI Backupper Pro:
1 - Those with PCIe drives (and haven't found cloning software that works on them).
2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…