MSSQL

  Spatial Index can only be created on Spatial columns. That is, the type of column must be geometry or geography. Let’s create a table …

  SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …

  The Filtered Index is a filtered nonclustered index. For example, you have 100,000 records in a table. And some of your queries are only …

  The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …

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 …

  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 …