Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What are the system database in sql server 2005?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

---

What is lock escalation? : sql server database administration

0 Answers  

---

How to create a simple table to test triggers in ms sql server?

0 Answers  

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

Difference between drill down and drill through report.

0 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---