MSSQL

  You may receive this error when you want to import data from a file such as Excel to the sql server. You must install …

  We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details …

We use the WITH ROLLUP and WITH CUBE operators with the GROUP BY statement. So before you read this article, I suggest you read the …

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 …