What is the difference between a clustered and a non-clustered index? What are the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN? Can you write a view with identify it's prermitions What is the difference between a stored procedure and a function in SQL Server?