Most database experts, or TSQL developer knows EDIT TOP 200 Rows option. When you click EDIT TOP 200 Rows by right-clicking on the table, unlike …

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

  There may be a slowdown when you query dba_free_space or tablespaces via Toad on 12C databases. The slowness is due to the fact that …

  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 …

You can see “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.” warnings at certain intervals in the database alert log file. …

  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 …

  If the RMAN restore hangs with the “starting implicit crosscheck backup” error and has not been completed for a long time, you may have …

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