What the different components in replication and what is their use?
Explain view in sql server?
How will you optimize a stored procedure optimization?
How to copy data from one table to another table?
How to create a large table with random data for index testing in ms sql server?
How do I know if localdb is running?
How to list all stored procedures in the current database using ms sql server?
how many type of indexing in database?
What is the default fill factor value?
What is the use of floor function in sql server?
Tell me what are cursors and when they are useful?
Define cross join in sql server joins?
Differentiate between delete and truncate.
Explain the collation?
how would you store your query in an SSRS report or a Database server?