What is the purpose of object explorer and its features? : sql server management studio
How to fetch the next row from a cursor with a "fetch" statement?
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to create Clustered Primary Key to table?
How you provide security to cube? : sql server analysis services, ssas
How many types of triggers in sql server?
what do you understand by change data capture?
What are the dmvs? : sql server database administration
how would you improve etl (extract, transform, load) throughput?
Tell me what is fill factor?
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
Will the writetext statement activate a trigger?
How can you list all the table constraints in a database?