Tips for using Very Large Databases in SQL Server 2016 Try to create as many database files, as there are physical disk arrays so that you have one file per disk array. This will improve performance, because when a table is accessed sequentially, a separate thread is created for each file on each disk array in order to read the...
Tag: distributed partitioned views
Some tips for using views in SQL Server 2016
Some tips for using views in SQL Server 2016 Use views to enhance security and conceal underlying data objects. For example, you can give to users the permission to access a view, which contain a restricted set of the columns and data, not allow selecting or updating the underlying data objects. By using views, the permission management could also be...