How to resolve error “system.data.sqlclient.sqlerror write on “???” failed ” observed during restore of SQL DB.
SQL Server 2008
This article helps to resolve SQL Server message – Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.
Find the SQL Server Edition using simple command
Article on how in SQL Server Not Null Column is added to an Existing Table which has millions of existing records.
This article provides queries to determine Index Fragmentation for all databases or specific database or specific table in database.
Are you facing SQL Server 2008 DB resource deadlock and DB connection issues? Check this article to find list of active sessions, find the number of connections established from each server/ client and total number of active connections and blocking processes.
Msg 50000, Level 16, State 1, Procedure Name: ‘XYZ’ Severity Code: 14 Error State: 1 Error Number: 2627 Error Line: 2833 Error Message: Violation of PRIMARY KEY constraint ‘PK_XYZ’.
If you are facing below error while executing the stored procedure – Msg 50000, Level 16, State 1, Procedure Name: ‘XYZ’ Severity Code: 14 Error State: 1 Error Number: 2627 Error Line:2833 Error Message: Violation of PRIMARY KEY constraint ‘PK_XYZ’. Cannot insert duplicate key in object ‘ABC.24_RPT’. This is user defined error and you need […]
One of our client reported that SQL Server is using almost 100% memory on the server. After analysis we found that what our client observed was actually designed behavior of SQL Server. When Microsoft SQL Server is started, it slowly starts using memory and after some time you may observe that whole memory is used […]
There are different ways to find the DB size. The easiest way is: 1. Login to SQL Server Management Studio –> Select the DB—>Right click on Properties The popup as shown below will show the DB size- The size shown 3743.38 MB is sum of Data and Log files. Point to understand here is that […]
If SQL Server 2008 is showing 100% CPU usage then following actions should be taken to find the cause of the problem and to rectify it. 1. Verify in Task Manager—>Processes, that Sqlserver.exe is using 99% or 100% CPU activity. 2. Invoke Activity Monitor in SQL Server Management Studio to check the processes taking most […]