why would you call update statistics? : Sql server database administration

0 Answers  

---

wat new abt truncate in sql server

2 Answers   HCL, HP,

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

Tell me what is difference between view and materialized view?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

What is temporary stored procedure?

0 Answers  

---