Tuesday, March 18, 2014

SQL Server max memory and number of processors by edition

SQL Server scale limitations, maximum memory and maximum number of processors utilized for each edition and version of SQL Server, from SQL Server 2005 to SQL Server 2014, are presented in this one page, easy to print pdf document:  http://www.xsql.com/content/SQL_Server_Max_Memory_And_Processors_By_Edition.pdf

The information contained in the document has been collected from publicly available sources and is presented as is. If you find any inaccuracies or misrepresentations in the document please contact us.

While you are here, take a few minutes to check out our recently released xSQL Schema Compare and xSQL Data Compare tools - they are the best tools for the job and they are totally free for SQL Server Express, no restrictions, no limitations.

Monday, March 10, 2014

xSQL Compare Bundle V5 with support for SQL Server 2014 released

We just released version 5 of our SQL Server comparison and synchronization tools, xSQL Schema Compare and xSQL Data Compare, with full support for SQL Server 2014. The release notes provide a more detailed description of what's new in this version. Here is a summary:
  • SQL Server 2014 support: full support for SQL Server 2014 including all new and improved SQL Server 2014 objects such as memory-optimized filegroups, memory-optimized tables, hash and range indexes, columnstore indexes, memory-optimized table types, natively-compiled stored procedures, primary and secondary selective xml indexes, Xml index and namespace paths, etc.
  • New comparison options:  in xSQL Schema Compare you can now choose to include/exclude database filegroups and memory-optimized tables from the comparison and synchronization, whereas in xSQL Data Compare you can now choose to include/exclude from the comparison memory-optimized tables and columnstore tables.
  • Filegroup mapping: xSQL Schema Compare version 5 introduces filegroup mappings feature that allows you to easily handle complex database comparison scenarios involving databases with different filegroup structures.
  • Improved workspace: consistent look, feel and functionality in both comparison tools the xSQL Schema Compare and the xSQL Data Compare; new coloring scheme for comparison sessions allowing you to better organize the comparison sessions in the workspace; separate tab for schema snapshots etc.
xSQL Schema Compare V5 supports SQL Server 2014, SQL Server 2012, SQL Server 2008/2008R2, and SQL Server 2005.
xSQL Data Compare V5 supports SQL Server 2014, SQL Server 2012, SQL Server 2008/2008R2, SQL Server 2005, and SQL Server 2000.
You can download the new version of the comparison tools as one package from: http://www.xsql.com/download/sql_server_comparison_bundle/