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).

Explain difference between control flow and data flow?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

What are the different index configurations a table can have?

0 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

Why Do you want to work in this company?

4 Answers   HCL,

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What is single-user mode?

0 Answers  

---

What is bit data type?

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

---