Software Applications Programming Errors and solutions.

Tips to Free Up Disk spaces Default Cube Deployment in Ax 2012 Power BI With data connect Data base Shrinking Enable database log on table in Axapta

This is SQL Command chart we read it from starting of any computer diploma which include oracle and SQL. DDL is data definition language,DML is data manipulation language ,DCL is data control language and TCL is Transaction control. TCL Include Set transaction also. DML Include Merge,call ,explain plan,and lock table command too. DDL include comment also.

Below is some details or example what is the use of 'CACHE' ,'NO CACHE' option in sequence 1.Suppose cache is 10 so it will store the next 10 values in advance and that time it some issue happenes with database .we will lose that stored values 2.Values will be fetched from memory by pre-generating them to reduce I/O 3.Cache in sequence specifies that how many values will be stored in memory for faster access,It's default value is 20.

Difference between view and Materialized view  (i) View will not store any data,whereas Materialized View will store data. (ii)View is used for security purpose and Materialized View for performance. (iii) view is not accessible if base table is dropped, whereas in Materialized View it can still be accessible. (iv) Can perform DML operation directly on view but it Materialized View its not possible. Define Long Column LONG columns cannot be in the SELECT clause when using the UNION set operators. There are some restrictions for long columns like.  (i) It cannot appear in where clause. (ii) Indexes cannot be created on them. (iii) It cannot appear in Group by,order by, or connect by clauses or with the distinct operator in select statements.

If you are facing following error which Database space error on Sql server for ERP. "The database reported (session 2 (-AOS-)): Database space problem - 'AX2009_Test' is out of space" Then you can do following to resolve this error. 1. Clean unwanted file from c drive or other drive where database stored. 2. Shrinking database log and data files can also help to free some space. 3. If you database size growing fast then increase hard drive volume or move database to other drive. 4. Clean log files which is bigger size. 5. Use disk cleanup tool. 6. You can Shrink other database which is not related to ERP.