How can we delete Duplicate row in table?
What is a transaction and what are ACID properties?
Explain log shipping and mention its advantages.
How do we know if any query is retrieving a large amount of data or very little data?
Describe about first three Normal forms.
What do you understand by integration services in sql server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car
What types of Joins are possible with Sql Server?
Explain important index characteristics?
Tell me what is normalization? Explain different forms of normalization?
How is table type constraint applied to a table?
Diffrences between sql server 2000 vs 2005