Explain what are magic tables in sql server?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What is row_number () and partition by in sql server?

0 Answers  

---

Explain what is lock escalation and what is its purpose?

0 Answers  

---

what is a live lock? : Sql server database administration

0 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

---

What are filegroups in sql server?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What is dirty read?

0 Answers  

---