MSSQL

With the DATALENGTH function, we can calculate the size of the data in a column in bytes. Usually, its useful for calculating the size of …

  With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail …

  With the @@ SPID Function, we can find the session id of the current session. Usually we use when we want to exclude the …

  Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes …

Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. …

Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …

  You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you …

If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. …

  If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When …

  When you try to delete the Primary table in tables that have a Primary Key Foreign Key relationship, you receive the error as follows. …