MSSQL

SQL Server supports grouping of data with GROUP BY since older versions, and also offers WITH ROLLUP and WITH CUBE operators for grand-total and sub-totals. …

  Creates a checksum value of a data set. You can use it to check if data in a column is being modified. accepts int …

  You moved the database to another instance and created a new login for this database instead of moving the login from the old instance …

  This function returns an estimated number of non-null unique values in a data set. It came with SQL Server 2019. Let’s create a table …

  You receive this error when you try to convert a string that is a not compatible with the datetime data type to a datetime. …

  We use the AVG function to obtain the average value of the specified column. Its one of the most used SQL Server functions. Let’s …

  We can capture Query Timeouts by using SQL Server Extended Events Session. Right click on Management-> Extendend Event-> Sessions on SSMS and select new …

  We send a dataset to a function by grouping it with the Partition By statement int the OVER Clause. We sort the groups by …

  Constaint allows us to set specific rules for data in a table. For example; to make sure that the data in a column is …

  We can use “NOT NULL Constraint” to prevent values in a column from containing null data. Example: In the following example, when creating a …