SQL Server scaling techniques

Database system scaling is an important topic. Planning and design of a database system should include methods for scaling - upwards and outwards. Requirement to scale examples are; (a) change of focus on data gathering , which leads to different size of datasets b) business acquisition which requires integration with other systems. Some features I've found useful in SQL Server for scaling are: -Partitioned Views -Service Broker -Services Oriented Database Architecture(SODA) -Compression -Data Dependant Routing (DDR) -Table Partitioning A Partioned View splits data from a larger table into smaller tables (member tables).The partitioning occurs via a range(s) of values in... Read more →