Software Applications Programming Errors and solutions.

Interview Cracking Steps 1) Resume : Mention all the skills and achievements. Be true to yourself and do not exaggerate. Develop good command on all the topics which you have mentioned in the resume.  Review your resume thoroughly and make sure it is error free and properly formatted. 2) List down the topics which you are strong at. Leverage this point to highlight your skills during your interview. Show your contributions as a team member which help to perform tasks easier. 3) List down the topics which you are weak at 4) Make a note of your recent achievements like issues, new implementations, automation, standardization and documenting. Make sure you have some stories to tell. This will help in giving a good idea about your skills and the interview would be held in these areas mostly. Interview: Common questions 1) Tell me about yourself- Make sure you are well prepared for this. This gives and idea about yourself as well as you communication skills. 2) Tell me the

Question -Employee_Details EmpID NVARCHAR(10) Emp_FirstName NVARCHAR(100) Emp_LastName NVARCHAR(100) DateOfJoining Datetime Employee_Salary EmpID NVARCHAR(10) Refers to Employee Details PayPeriodId INT Refers to Master_PayPeriod SalaryAmount Money DateofSalaryCreditedtoAccount Datetime Master_PayPeriod PayPeriodID INT PayMonthYear Datetime Employee Details Sample Data 000001 ABC XYZ 01-Jan-2000 000002 Rahul Y 13-Dec-2000 000003 Amit S 12-Apr-2000 000004 Shobit K 01-Jan-2000 000005 Harshit J 13-Dec-20

This is sample of queries to check in MS SQL 2012 How to Fix Error "ERROR 9002 LOG FILE IS FULL" You can check following way.

If you are getting Microsoft SQL Server Error 18456 Login Failed for User sa error to connect with system admin (SA) Login. Then you can apply below step to resolve this issue Go to SQL Server Properties - Security - Server Authentication section- check Sql Server and Windows authentication mode After that restart SQL server services then it will work fine.