Today we are going to see the trace flag 1117. Have you ever heard or read that all your data file should be in same size? Wonder why? Let’s assume you have four files in a database which is not equally sized then SQL Server will utilize the data file which is largest in size,… Continue reading Day 6–Trace Flag 1117– Auto Grow Equally in all Data file