This article describes how to remove availability database(s) from an Always on Availability Group by using SQL Server Management Studio and Transact-SQL. Here, we will be removing primary database from availability group that will remove corresponding secondary database from AOAG...
Today, I will explain how to fix SQL Server error 53 (The network path was not found). The details about SQL error 53 are given as “A network-related or instance specific error occurred while establishing a connection to SQL Server....
I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that was suggested by the vendor. We need to set database size to 700GB keeping 150 GB to log files. I...
Have you even face that your transaction log file is growing exceptionally and you have to manage log file to make it in his size limit? Managing transaction log file is not an easy job if you have to run...
Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details of that issue are given below: Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed) , included attributes (0),...
Today, a user has raised a request to fix an error (Microsoft SQL Server Error 40 – Could not open a connection to SQL Server or Microsoft SQL Server, Error 2) he was getting while establishing the database connection. Sometimes you might...
DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command provides transaction log space statistics and wait statistics information at instance level and we also use it to reset wait and...
Resumable Online Index Rebuild is a new feature introduced in SQL Server 2017. Index Rebuild operation is very expensive task that takes lot of system resources and log spaces during execution. Sometimes, we need to cancel index rebuild operation in...
Here, we are going to talk about disk and performance Impact of online Index rebuild operation. As we know index rebuild is offline operation due to which indexes become inaccessible. Here, I will describe about SQL Server rebuild index online...
Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends on case to case. Ideally, you should not clear your wait statistics data frequently. Best way is Do Not clear wait...
If you want to change putty background color from black to white or any color as per your choice then you should keep reading this article. If you are working for several customers, you can configure distinct colors for their...
Yesterday, a developer has reported an SQL Server error 18456 Login failed for user ‘username’. (Microsoft SQL Server, Error: 18456) on one of the SQL Server instance that are running in lower life cycle. The details about SQL Server error...
Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might have faced at least once in their career. It belongs to SQL Server connectivity issue SQL Network Interfaces Error 28....
SQL JOINs are used to retrieve set of information from two or more different tables based upon certain common values between them. We use joins to combine tables with Select SQL statements. Related Articles: Read UNION vs UNION ALL Logon...
Last week we had received some requests to rename or change hostname of RedHat Linux systems. We got these requests because the hostname of these linux servers were not as per the server naming convention standard. Here, I will explain...
