You can get this error when you want to inset data into a table that has the Foreing Key. It means that there is …
Read More »How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State
Users’ passwords are valid for the duration of PASSWORD_LIFE_TIME in their profile. At the end of this period the password expires and must be …
Read More »Setting the Database AUTO_CLOSE Option to OFF to Improve Performance
Auto_Close is an option of the database. If set to ON, the database is opened and closed each connection. The procedure cache is cleared …
Read More »@@VERSION, SERVERPROPERTY and @@MAX_CONNECTIONS Functions in SQL Server(TSQL)
The maximum number of connections that an instance can accept varies by version. With the @@MAX_CONNECTIONS function, we can query the number of default maximum …
Read More »How To Move OCR and Vote Disks to Different ASM Disk Groups
Generally, for the Oracle Cluster Registry and Vote Disks, the disk group where the database files are stored is used in RAC Systems. The …
Read More »Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail
You can receive this error even if you configure Database Mail and activate it via sp_configure. You can reach details in my article “How …
Read More »PostgreSQL – psql – gexec
As database administrators or software developers, we sometimes write sqls that produce sqls. We save the output to the file. Then we run this file …
Read More »PostgreSQL – format sql with pgFormatter
pgFormatter can format a SQL file according to the options. It can also be used as a CGI. Also is simple to use. The basic …
Read More »SET LOCK_TIMEOUT and @@LOCK_TIMEOUT Function in SQL Server(TSQL)
With SET LOCK_TIMEOUT, we can set the maximum amount of time a session will wait to access a blocked resource in milliseconds. If a …
Read More »How To Export SQL Server Table to CSV File
We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv …
Read More »