| Other SQL Server Interview Questions |
|| Asked @
|what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
|What are the different types of replication? How are they used?
|How to find the latest updated value in a table without
sending any parameters to that query
|What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes?
|How to truncate a table first before running a package?
|What is difference between stored procedure and function?
|Rate yourself in .NET and SQL ?
|what is the diffrence between Snap Shot and Transaction
|What is blocking and how would you troubleshoot it?
|How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
|What is Primary key and foreign key? Give an example
|How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
|For more SQL Server Interview Questions Click Here |