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…
7 years ago
Manvendra Deo Singh
Fix Error 15123: The configuration option does not exist.
Yesterday, one of my teammate was facing an issue while enabling a server level parameter using T-SQL command sp_configure. He was trying…
7 years ago
How to Find When SQL Server was Installed?
Have you ever thought when SQL Server instance was installed on your machine? If you don't have idea about finding…
7 years ago
Fix Error 18452: Login failed. The login is from an untrusted domain
Recently a user has reported error 18452 while connecting to database server. Full description of this error is given below:…
7 years ago
How to Enable, Disable or Check SQL Server Trace Flags?
Trace flags are used to gather in-depth information about certain logs during some transactions. We use DBCC commands to enable…
7 years ago
Fix Error 1418: The server network address cannot be reached or does not exist.
We got error 1418 while configuring Database Mirroring on one of the SQL Server database instance. The error details are…
7 years ago
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
Understanding Database Shrink Operation and Why Should We Avoid It?
Database Shrink is a process to remove unused space allocated to the database or database files to the disk. When…
7 years ago
SQL Server Evaluation Period has Expired and How to Upgrade it?
Generally, we download SQL Server evaluation edition to learn or do some testing before deployments. Evaluation edition of SQL Server…
7 years ago
Fix SQL Server Error 233: No process is on the other end of the pipe
Today, I got SQL Server error 233 no process is on the other end of the pipe while connecting to…
7 years ago
SQL Server Alwayson Interview Questions & Answers
I have published SQL Server Interview Questions and Answers on many topics. Visit attached link to get All SQL Server…
7 years ago
New T-SQL Functions Introduced in SQL Server 2017
SQL Server 2017 is feature rich product that has been launched with multiple new features. You can read attached article…
7 years ago
How to Upgrade or Patch Alwayson Availability Group Instances?
If you are planning to upgrade your SQL Server instance that hosts an Always on Availability Group (AOAG) to a…
7 years ago
Restore a Database Participating in Alwayson Availability Group
Sometimes, we need to restore a database that is part of always on availability group to fulfill our business needs.…
7 years ago
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