You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

What are the differences between user defined functions and stored procedures?

0 Answers  

---

Can XML be used to access data?

2 Answers  

---

How would we use distinct statement? What is its use?

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 is table join?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

What are system databases into sql server (2005/2008)?

0 Answers  

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

How to set database to be read_only in ms sql server?

0 Answers  

---