We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. DATEFROMPARTS: It takes year, month and day values as parameters and returns a value in the date data type. Sample Usage: [crayon-5c6e92a94eb29275525555/] DATETIMEFROMPARTS: It takes year, month, day, hour, minute, […]
When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of the databases as the sa user. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. […]
When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob column. There are two main reasons for this. You can have a corruption in the lob column in the related table The lob retention value of the Related Table […]
The “Cursor Mutex S” wait event occurs when two different sessions try to make hard or soft parsing on the same query. As a result, it is possible to see a high number of query versions in the shared pool or see the high CPU usage. Queries must be identified, modified to use bind […]
ColumnStore Index entered our lives with SQL Server 2012. Normally the index is stored in the disk as row-based, and the index is created by combining these rows. ColumnStore Index is created by combining these columns. So, Its stored as column-based. This feature was typically used for the datawarehouse in SQL Server 2012. According […]
We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If the int data type is insufficient for the difference between two dates, you should use the DATEDIFF_BIG function. You can use it in the same way as DATEDIFF function. Only […]
The global cache service (LMSn) processes copy consistent copies of blocks in the buffer cache to the requesting instance’s foregound process. LMS also performs a rollback on uncommitted transactions in the requested block. The number of LMS processes is 2, unless otherwise specified. This number is not sufficient for RAC databases with heavy transaction. […]
Before reading this article, I recommend that you read the articles “How To Configure Database Mail on SQL Server” and “How to Create an Operator on SQL Server“. Briefly, you can send e-mail the problems related sql server to dba group using Database Mail and Operators. Configurations related to Database Mail and Operators are […]
With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add. The DATEADD Function is one of the most used date functions. datepart Abbreviations year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww weekday dw, w hour hh minute […]
To configure Automatic Memory Management(AMM) in databases that do not use AMM, it is necessary to change the required parameters and restart the database. When AMM is active in Oracle databases, if the memory values grow and shrink too frequently, “database: pin S wait on X” or “library cache lock” wait events can be observed […]
