Software Applications Programming Errors and solutions.

Lets If You have  have data in following format in Excel 1*(4+3.00)/2*3 5*(4+5.00)/2*4 1*(5.30+300)/2*4 1*(2.30+400)/2*3 1*(5.30+3.00)/2*4 1*(t.30+3.00)/2*3 You  want to convert it in formula ( Result ) without entered "=" manually. how cant it possible ? Solution: Download and install ASAP Utilities ( http://www.asap-utilities.com/ ) Open your worksheet. Select all the cells that you want to convert. In the ASAP Utilities menu: Go to "Text". Click on "Insert before and/or after each cell in your selection". Put in an = sign in the "add before:" box. "treat cells as:" values (default) Click on "OK". Now, press and hold Ctrl. Press the "H" key. That will open the "Find and Replace" dialogue box in Excel. (Type an = sign into both boxes.) "Find what:" = "Replace with:" = Click on "Replace All".

If you want to kill any sql process for which your system is being hang or any other problem then you can read following comments. Get SPID of process then write following command at sql query browser. KILL 121 WITH STATUSONLY spid 121 : Transaction rollback in progress. Estimated rollback completion: 80% Estimated time left: 10 seconds. ReRun the same. spid 121 : Transaction rollback in progress. Estimated rollback completion: 99% Estimated time left: 1 seconds.

You can get Difference in Exists and In operator in sql query by below example. Using SQL server database 2008 R2 in query editor. SELECT * FROM Dept where DeptID IN (select Deptid from subDept ) SELECT * FROM Dept where exists (select Deptid from subDept ) This a simple example where I know the second query will execute faster than the first. The qualifier "if both Deptid columns are unique" is a critical requirement in order for the JOIN to produce the same results as the IN. So: •JOIN will produce one row for each matching row in subDepts. •IN will produce only one row if there is one or more matching rows in subDepts •EXISTS will produce one row if there are any rows in subDepts regardless of whether they match or not

Nulls are neither good nor bad. NULL is simply the absence of data. How one deals with NULL is entirely dependent on the environment you are working within. The various forms of VB and xBase platforms seem to be  the worst at accommodating NULL within code. So, from that perspective, . However, from a database perspective (excluding MS-Access) a column having a NULL state is actually useful information (the absence of a value). I find NULL to be a useful data state, in that this clearly indicates that a value has either not been set, or specifically cleared. It's a pain to deal with fields that can either contain a value, blank, or null. It's just a bunch of extra coding to deal with the variations when writing code. It is different from dealing with results from a query where there is a left join that returns a null value.

To get common Sql server developer interview question and answer you can visit following website link. Sql server developer interview question and answer To get question related to sql authority you can visit link below. SQL Server Journey with SQL Authority To get some common quesion and answer related sql database. SQL Server - Common Interview Questions and Answers

If you are going to attend Team leader /Project manager interview then some common question you should prepared. I am sharing link where you can get some idea about answers of some typical question. If you read it in advance then interview will be easy for you. Project Manager Interview Questions and Answers 50 interview questions You can get lot of questions and answer for different categories here Interview Questions I hope after reading all answer your confidence level will improve.

clear cache Clear cookees,history,cache,data trafic,serch history etc try google chrome to use google products like gmail,google,google plus etc. delete temporary files. Go to run->write temp->del all files->den go again in Run and type %Temp% and del all files here also!! Use Disc cleanup and defragment utility of disc properties. Clean desktop items. Delete unused user profiles from document and settings folders.