Explain some stored procedure creating best practices or guidelines?
what are constraints? : Sql server database administration
What is the recommended total size of your memory optimized tables?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What does it mean to invest in the index?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
What is primary key and example?
What is Inner Join?
How to get the definition of a stored procedure back?
Do you know what is normalization of database? What are its benefits?
Explain SELF JOIN ?
Should you normalize audio?
How many full-text indexes can a table have?