Showing posts with label data files. Show all posts
Showing posts with label data files. Show all posts
Wednesday, May 31, 2017

SQL Server AUTOGROW_ALL_FILES Option

›
Few days back, I wrote an article on SQL Server default behavior when it expands files with AutoGrowth enabled. Where there are multiple f...
Monday, May 22, 2017

SQL Server does not always write data to files, proportional to the amount of free space in each file

›
We add multiple data files to file groups to get data distributed (it is always better to get them distributed among multiple physical vol...
Wednesday, April 12, 2017

How to find the related file and the page numbers of records in SQL Server data table

›
Sometime, for some administration works, we need to know which file has been used for holding our records and the related page numbers. Ho...
Tuesday, September 27, 2016

How many times my SQL Server files have grown?

›
If you have not changed the default Growth Rate settings in SQL Server files, then the default will be applied. SQL Server 2016 is smart, ...
Friday, May 13, 2016

SQL Server On-Premise Database files maintained in Azure

›
This is not about databases completely maintained in cloud, this is about databases created and maintain on-premises but data and log file...
Saturday, May 23, 2015

How to decide the number of data files required for tempdb?

›
If your tempdb is used heavily and experiences some slow performance with it, adding multiple data files might help to improve the overall...
Tuesday, June 17, 2014

What are the advantages of a SQL Server database with multiple files located on one physical drive ?

›
This is a common question I always get from my classes/workshops. Do we really get some benefits out of a database with multiple data files ...