Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

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

  In RAC databases, serious cluster wait events are seen, usually due to the low speed of interconnect interfaces. Therefore, after the installation, faster hardware interfaces …

  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 …

  ORA-00313 error can be received depending on any problem in redo log files in standby database. The possible error message will be as follows. …

  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 …

  The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …

  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 …