Tag: partition

Pro Members SQL Server Standard Members

Some tips for using SQL Server 2019 file and filegroups

by

Some tips for using SQL Server 2019 file and filegroups Consider placing the tempdb log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it is important that the disk arrays containing the tempdb log files have sufficient disk I/O performance. Set the maximum size of the data and log files....

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 →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 file and filegroups

by

Tips for using SQL Server 2012 file and filegroups Microsoft SQL Server 2012 introduces many new useful stored procedures, functions and operators. Some actions you can perform without these new features, but usually using them provides more easy and effective way to accomplish the same goal. For example, Microsoft introduces SQL Server FILESTREAM technology that enables SQL Server-based applications to...

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 →