Define the one-to-one relationship while designing tables.
What is sql server replication? : sql server replication
Explain the truncate command?
How can I get data from a database on another server?
What is the stuff?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship
Can we create clustered index on composite key?
How do you measure the performance of a stored procedure?
What is a partition key?
Do you know what is difference between index seek vs. Index scan?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Is foreign key a primary key?