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....
Tag: partition
Troubleshooting SQL Server 2014 Bulk Copy Problems
Troubleshooting SQL Server 2014 Bulk Copy Problems If you have problems with SQL Server 2014 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the […]
Tips for using Very Large Databases in SQL Server 2012
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...
Tips for using SQL Server 2012 file and filegroups
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...