MSSQL

  You can specify the date format that the corresponding session accepts with “SET DATEFORMAT”. You may need this command if you want to assign …

  Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server …

  The CAST and CONVERT functions are conversion functions. We use these functions to convert a data type to another data type. Of course, every …

  You may need to uninstall a replication that you previously installed and drop the database. You may receive an error if you want to …

  The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …

  If you want to delete the database, you will get this error if there is an open session on the database. First, set the …

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 …