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 lob columns. Let’s make examples …

  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 Profiles are set as global …

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

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

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. But conditions may not always …

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 (insert – update – delete) …

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

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

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

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