Software Applications Programming Errors and solutions.

Cross join Each row from testtable1 will return with each row from testtable2 because there will be no join condition. without joining condition we can return multiple data from tables using cross join,but cross join based on  Cartesian  product.it will return total rows,for example employee table has 14 rows,dept table 4 rows,14*4=56 rows it will return. use to retrieve the data from more than one table with out any condition.no need to have any common column b/w to apply this join.because,20 employee and 4 dept so 20*4=80 it will return the 80 rows selected. This kind of thing is called as Cartesian Product. If where clause is used with CROSS JOIN, it works like an INNER JOIN in query . SELECT     col1,col2,col3 FROM       testtable1 CROSS JOIN     testtable2 Inner join SELECT     col1,col2,col3 FROM       testtable1 INNER JOIN     testtable2 ON testtable1.id1= testtable2 .id1 These 2 examples will return the same result: Cross join select * from testt

GST Stands for Goods and Service Tax. Other coverage you can see on below image.

This is Career path for Software.. Salary is depends on experience . I can not define salary for all level but As I am technical so I can define probable salary for Axapta Technical Experience wise. 1.Ax Fresher Technical- Starting salary should be 3.5 lacs per year and most companies use bond sign also.. 2. If person is experience for upto 3 year than salary range goes to 4.5 lacs to 7 lacs . 3 If person experience is 4 to 10 year  then salary range goes to 7 to 17 lacs.  4. If experience is more that 10 year then salary goes to 18 lacs to 25 lacs. 5. If person reached to 25 lacs then chances of salary start for decrements. Its also depend upon institute and course salary may have variation. 

1. Buffer pool too small 2. Inadequate Disk I/O subsystem 3. I/O bottleneck 4. Missing Indexes 5. Low index usage like  poorly design indexes 6. Temp DB contention 7. Data and Log file are on same drive 8. Slow network 9. Client side performance issue 10. Query plan not updated or poor 11.If Update statistics not updated 12.Memory configuration setting not done properly 13.Lock page memory not configured with sql service user.

What is LSN chain in SQL Every trasaction in sql server is identified by lsn number .means log sequence number If LSN is broken then u may not able to restore it. Hope LSN needed in order to perform restoration. LSN means log sequence number. Log file consists of internally log sequence number. If LSN is miss match we can't to restore data at point of time. We can restore For e.g you have 1 full back and 4 log files, suppose if ur LSN broken on 3rd log file, then we can restore up to log file 2 rest all we can't restore it.

E-Business Suite Manufacturing, E-Business Suite E-Business Suite Manufacturing, E-Business Suite Procurement, E-Business Suite Project Management, E-Business Suite Supply Chain Management, -Business Suite Tools and Technology Hoodp SAP Cisco Certification, sales force, informatica, tera data, Oracle 11g/12c(OCA,OCP), Weblogic, ITIL,Sharepoint, Java,.Net, MicroSoft, E-Business Suite, E-Business Suite Financial Management, E-Business Suite Human Capital Management, Endeca Oracle Endeca Commerce, Fusion Applications, Fusion Governance Risk and Compliance, Hyperion, Data Relationship Management, Hyperion Financial Management Planning, JD Edwards EnterpriseOne, JD Edwards Financial Management, JD Edwards Project Management, JD Edwards Supply Chain Execution (Logistics), JD Edwards Tools and Technology Manufacturing and Engineering, ATG Web Commerce, ATG Developer, Agile, Agile Product Lifecycle Management, CRM On Demand, Oracle CRM On Demand, Deman

Checkpoints occur in the following situations: 1. A CHECKPOINT statement is explicitly executed. A checkpoint occurs in the current database for the connection. 2. A minimally logged operation is performed in the database; for example, a bulk-copy operation is performed on a database that is using the Bulk-Logged recovery model. 3. Database files have been added or removed by using ALTER DATABASE. 4. An instance of SQL Server is stopped by a SHUTDOWN statement or by stopping the SQL Server (MSSQLSERVER) service. Either action causes a checkpoint in each database in the instance of SQL Server. 5. An instance of SQL Server periodically generates automatic checkpoints in each database to reduce the time that the instance would take to recover the database. 6. A database backup is taken. 7. An activity requiring a database shutdown is performed. For example, AUTO_CLOSE is ON and the last user connection to the database is closed, or a database option change is made that req