What’s New in Database Design and Performance

Many of the database design and performance considerations that applied to previous versions of SQL Server still apply to SQL Server 2014. These principles are basic in nature and are not affected by the version of the database management system. This chapter focuses on those relatively unchanged principles.

There is, however, a new section in this chapter that focuses on running SQL Server in a virtual environment. Running SQL Server in a Virtual Machine (VM) has been an option for some time but was generally frowned upon because it was difficult to get acceptable performance in this type of environment. Advancements in the VM Software, the underlying Operating System (OS), and improved hardware ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.