DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS Function in SQL Server(TSQL)

21 Feb by dbtut Tags: , , , , ,

DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS Function in SQL Server(TSQL)

  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, […]
21 Feb by dbtut Tags: , , , ,

How To Change Owner of Database in SQL Server(ALTER AUTHORIZATION)

  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. […]
21 Feb by dbtut Tags: , , , , , , , , , , ,

Data Pump Export process ends with ORA-31693, ORA-02354 and ORA-01555 errors

  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 […]
20 Feb by dbtut Tags:

SQL Server Columnstore Index(2012,2014,2016,2017)

  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 […]
19 Feb by dbtut Tags: , , , , ,

Increasing the performance of global cache service(LMSn) in Oracle

  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. […]
19 Feb by dbtut Tags: , , ,

Make Sure that Database Mail is running in SQL Server(Failsafe Operator)

  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 […]
18 Feb by dbtut Tags: , , , , , , , ,

DATEADD Function in SQL Server(TSQL)

  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 […]
18 Feb by dbtut Tags: ,

Configure Automatic Memory Management in Oracle

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 […]