all_about_SQL

Let say there are two tables Table A and Table B joined together with multiple conditions seperated by "OR" clause, due to this optimizer is selecting index spool operator to process the data, is it optimal or should be changed in terms of better performance???

My opinion I will post by tomorrow...

SQL INTERVIEW -8
1) What is data validation stored procedure.
2) Important steps needed for data validation.
3) How to use a multiline table valued function for data validation.
4) Constraints can be applied or not in a table variable.
5) What statistics are needed to optimize a table variable.