Software Applications Programming Errors and solutions.

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.

To search subfolders and Add hyperlink for file from the top level folder using Macro code in Excel. You can take help from code below. Private Files As Dictionary Private StrFile As String Public Function FindFolder(strpath As String) As String Dim fs, f1, f2, FleCollection Set fs = CreateObject("scripting.filesystemobject&quot ;) Set f1 = fs.getfolder(strpath) Set f2 = f1.subfolders Set FleCollection = f1.Files For Each subfld In f2 FindFolder subfld.Path Next For Each fle In FleCollection Files.Add fle.Name, fle.Path Next End Function 'add below code before adding hyperlink If (Files Is Nothing) Then Set Files = New Dictionary End If 'Filename should contain Extension like "test.pdf" If Not ((Files.Exists(Filename))) Then 'replace c:\ with root folder of the file,if you are no sure about Root folder, You need to call it with all possible drives like "C:\" "D:\" etc

I got one good site which is Excellent Investment Calculator for diffierent purposes. You can visit following link. http://investmentyogi.com/Financialcalculators.aspx By this site you You can get following calculators Income Tax Calculator,Home Loan EMI,Double your money Calc,Systematic Investment Plan,Recurring Deposit Calc,Life Insurance Calculator,Fixed Deposit Calculator,SIP Investment calculator,Final return on monthly SIP,Annuity Calculator,Retirement Corpus,Save To Become Crorepati,CAGR Calculator,Insurance Calculator Future Value Calculator,Inflation Calculator,Interest Payable Calculator,Time To Become Crorepati Housing loan eligibility,Home Loan Refinance,Financial Health Calculator,Investment Planning Calculator etc.