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 …

  In some cases, we may need to move the lob columns in a table to another tablespace. You can do this with the following …

  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 …

  When access to the KVM switch in the Exadata cabinet, a “Network connect error” error can be received from Java. An error may occur …

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

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

  You can run commands on all the compute nodes or cell nodes from a single server on Exadata. We can use the dcli utility …

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 …