How to Add Data File to Availability Database?
Sometimes, we need to add data file to availability database in Always on Availability Group. Adding database file is a…
7 years ago
data file
SQL Server Error 5009: One or more files listed in the statement could not be found or could not be initialized
I had to add a log file to a database and then extend the size of this log file to…
7 years ago
How to Change Database Default Locations in SQL Server?
Sometimes, we need to change default database File locations to some other path in SQL Server. If you have configured…
7 years ago
How to Improve SQL Server Bulk Data Import Performance?
I am working on a project where we are migrating Oracle databases to SQL Server for SAP applications. We are…
7 years ago
What is Instant File Initialization and How to enable it on SQL Server Instance?
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a…
8 years ago