Fix Error 1101: Could not allocate a new page for database
We get error 1101 because of space issues. Database engine doesn’t able to allocate new pages to the database because…
7 years ago
log_files
Fix SQL Server Msg 5144 and 5145 for long or failed autogrow of data and log files
Whenever you extend the size of your data or log file with a larger value or your database perform autogrow…
7 years ago
4 Different Usages of DBCC SQLPERF in SQL Server
DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command…
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
Understanding SQL Server Recovery Model
A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not…
8 years ago
How to Get Total Number of Virtual Log Files inside SQL Server Database Log Files?
Today, i am going to discuss about virtual log files in SQL Server and query to find number of virtual…
8 years ago
Understanding SQL Server Transaction Log File Architecture
Today, i will talk about SQL Server Transaction Log File Architecture. As we know, every database must have at least…
8 years ago