What is SQL server agent?2 6451
What is the difference between a Local temporary table and a Global temporary table? How is each one used?2 17133
Difference between Cluster and Non-cluster index?32 126233
Rate yourself in .NET and SQL ?1 6157
What are the steps you will take to improve performance of a poor performing query?1 8466
What are the steps you will take, if you are tasked with securing an SQL Server?1 5768
What is blocking and how would you troubleshoot it?3 4918
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?3 8083
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?1 6270
What are statistics, under what circumstances they go out of date, how do you update them?2 6542
What are the different ways of moving data/databases between servers and databases in SQL Server?3 11741
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?2 7728
What is database replicaion? What are the different types of replication you can set up in SQL Server?5 21003
How to determine the service pack currently installed on SQL Server?4 7050
Can you have a nested transaction?4 8371
How are users differentiated in salesforce?
Differentiate between c3 and c4 plants.
How does a super charger work in a car?
How do pivot tables work?
explain all the classes with example
what is orthogonal matrix?
How can you check the level of fragmentation on a table?
What is the configuration files used in struts?
What is the difference between metadata and data dictionary?
What is the maximum size of string data type supported by hive? Mention the hive support binary formats.
When do we use the concept of effective sequence?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How does aspect oriented programming work?
How do you sum a condition in excel?
Define the Use of Pig?