MSSQL

  The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …

  The “Select Top 1000 Rows” and “Edit Top 200 Rows” options in SSMS are known to many people interested in SQL Server. I never …

  EXP Functions calculates the exponential value of a parameter that has the float data type. This function’s return data type is float. Below you …

  Most companies have a backup strategy, maintenance procedures. In my article “SQL Server Maintenance“, you can find details about maintenance on sql server. Therefore, …

  The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number …

  Checksum and TornPage Concepts are Page Verify Options. Page Verify is a SQL Server Database Property. Both are methods used to discover and report …

The ABS function returns the positive value of a negative number. The return data type is the data type of the input parameter. The ABS …

  Because of the problems that occur in the system databases, it is sometimes necessary to rebuild. Rebuild operation resets system databases and allows the …

If you are processing JSON data and the JSON data is not a valid JSON below error will be occurred. Msg 13609, Level 16, State …

master database is a database that keeps all the information at the system level in an instance. For example, logins, endpoints, linked servers, system configuration …