How to drop an existing schema in ms sql server?

0 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

What are secondary xml indexes?

0 Answers  

---

What is blocking and how would you troubleshoot it?

2 Answers  

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

---

What is index?

1 Answers   Cap Gemini,

---

What is a join in sql?

0 Answers  

---

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 defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

Explain the properties of a relational table?

0 Answers  

---