all_about_SQL

SQL interview -9
1) what is the difference between an index view and a normal view.
2) Query optimizer chooses which plan if query written on indexes view.
3) how to change to index selection.
4) what are the best index tuning steps.
5) is there any way to create multiple clustered indexes on the same table.
6) how many indexed views are possible on one table.
7) in what cases table scans are better and why?
8) Like operators give index seek with which type of Index.
9) How the query optimizer creates an ex*****on plan.
10) Index hints are good in which case.
, , ,

SQL interview -7
1) how to migrate stored procedures from one database to another.
2) Is there any method to make global stored procedures in databases
3) Creating a stored procedure in the master database can be accessed from all databases
4) Difference between system stored procedure and user defined stored procedure.
5) How to mark an object as a system object.
6) What are advantages if a stored procedure will be marked as a system object and can be accessed by all databases.

SQL INTERVIEW -5
1) How sample data can be selected from a set of rows.
2) what is percent sampling
3) why sampling is necessary.
4) can CTE be a solution for data sampling.
5) Which could be a better solution, CTE or Temp table and why
6) What statistics can be seen after data sampling.
7) If data rows are more than 1 million, what percent sampling would be a better case.

SQL interview -4
1) why openquery is used in SQL servers.
2) To use a different server what naming convention needs to be used.
3) what complex procedure is generally used.
4) is it possible to create a view with parameter,if yes how?
5) why we use exist and not exist.