What do you understand by triggers?
Tell me the difference between clustered and non-clustered index?
What is filestream?
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
What is the concept of optimization?
You want to implement the one-to-one relationship while designing tables. How would you do it?
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?
Explain Normalization and DE normalization
What is local temp table?
How do I determine how many instances of sql server are installed on a computer?
What are primary keys and foreign keys?
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What is the use of Port no?