SQL Solution center round-up – March 15th, 2014 – SQL refactoring techniques

In our latest blog articles, we focused on SQL database refactoring techniques

The most common reason for database refactoring is to improve performance, whether due to a bad database design or when dealing with a legacy database. What is database refactoring, what are other reasons for using it, and what are the elements of a refactoring process, see in SQL database refactoring – Introduction

SQL Refactoring techniques – How to split a table in SQL? explains two types of table splitting. One is vertical – where table columns are moved from one table to another. The other one is horizontal – both tables have the same columns, but records are split so different tables contain different sets of rows. The article shows how to sprit a table vertically using SQL code and ApexSQL Refactor

Related posts:

  1. SQL Solution center round-up – April 15th, 2014 – SQL Server database refactoring techniques
  2. SQL Solution center round-up – February 28th, 2014 – SQL refactoring techniques and SQL Server auditing
  3. SQL Solution center round-up – March 9th, 2015 – SSIS packages, SQL formatting, refactoring and more
  4. SQL Solution center round-up – January 15th, 2014 – SQL code formatting and SQL Server memory performance metrics
  5. SQL Solution center round-up – February 15th, 2014 – SQL formatting, recovery of deleted images, SQL Server auditing, security, and compliance
March 15, 2014