What is role playing dimension with two examples? : sql server analysis services, ssas
How are the unique and primary key constraints different?
What is the difference between constraints and triggers?
Where sql server usernames and passwords are stored in a sql server?
What is normalization 1nf 2nf 3nf?
How many cores do I need for sql server 2016?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is a db view?
Mention the uses of stored procedures.
What is statement level trigger?
How to transfer a table from one schema to another?
How to create a store procedure with encryption?
Can you explain powershell included in sql server 2008?