Answer / guest

WE CAN EVALUATE THE QUERY PERFORMANCE BY RUNNING THE
EXECUTION PLAN OF THE QUERY.IF THE QUERY NEEDS ITS
PERFORMANCE TO BE OPTIMISED THEN WE WILL BE CREATE A VIEW
FOR THE TABLE USING 'WITH SCHEMA BINDING ' OPTION ,THEN
SUBSEQUENTLY CREATE A MATERIALISED VIEW USING INDEX
DEFINITION.FINALLY CHECK FOR THE EXECUTION PLAN (THAT
PREVENTS THE EXPENSE OF I/O READS).

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

What is a deadlock and what is a live lock?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What is #table in sql server?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

Can we add our custom code in ssis?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---