Describe how to use linked server?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Give a example to search fr a string in all stored procedure in sql server.
Explain the etl (extraction, transformation, and loading)?
What is a trace frag?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is similarity and difference between truncate and delete in sql?
Difference between drill down and drill through report.
What is openxml in sql server?
What is replace and stuff function in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is scheduled job and how to create it?
Describe in brief sql server monitoring ways.
Differentiate between delete and truncate.
You want to implement the many-to-many relationship while designing tables. How would you do it?