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?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

Is it safe to delete log files?

0 Answers  

---

What is the use of keyword with encryption.

0 Answers  

---

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

---

What is the maximum row of a size?

0 Answers  

---

---

How you provide security to cube? : sql server analysis services, ssas

0 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

Why use view instead of a table?

0 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---