Tag: very large database

Pro Members SQL Server Standard Members

Tips for using Very Large Databases in SQL Server 2017

by

Tips for using Very Large Databases in SQL Server 2017 Create a user-defined filegroup and create some tables in it to run maintenance tasks (backups, DBCC, update statistics, and so on) against these tables. You can place a table in its own filegroup and can backup and restore only this table. So you can group user objects with similar maintenance...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using Very Large Databases in SQL Server 2012

by

Tips for using Very Large Databases in SQL Server 2012 Use distributed partitioned views to partition tables horizontally across multiple servers. By using distributed partitioned views you can greatly improve the very large database performance. Turn off the "automatically grow file" and "auto shrink" options for your very large database. Autogrowing and autoshrinking result in some performance degradation, therefore you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →