log space

Fix Error 1105: Could not allocate space for object in database because the filegroup is full.

Today, I got error 1105 on one of the database server. We were processing some bulk transactions on a database…

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…

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…