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 …
Read More »ORA-00313: open failed for members of log group Error on Standby Database
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. …
Read More »Conversion failed when converting date and/or time from character string
You receive this error when you try to convert a string that is a not compatible with the datetime data type to a datetime. …
Read More »AVG Function in SQL Server(TSQL)
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 …
Read More »How To Set Password Policy in Oracle
The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …
Read More »How To Capture Query Timeouts With Extended Events
We can capture Query Timeouts by using SQL Server Extended Events Session. Right click on Management-> Extendend Event-> Sessions on SSMS and select new …
Read More »OVER Clause in SQL Server(TSQL)
We send a dataset to a function by grouping it with the Partition By statement int the OVER Clause. We sort the groups by …
Read More »What is Constraint and SQL Server Constraint Types(TSQL)
Constaint allows us to set specific rules for data in a table. For example; to make sure that the data in a column is …
Read More »NOT NULL Constraint in SQL Server(TSQL)
We can use “NOT NULL Constraint” to prevent values in a column from containing null data. Example: In the following example, when creating a …
Read More »What is Result Cache and How do I use it?
Result Cache is the memory space in the shared pool area within the Shared Global Area (SGA). In this memory area, the database query …
Read More »