What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

What is a primary key?

0 Answers  

---

What is Trace flag?

1 Answers   Wipro,

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

---

Why and when do stored procedure recompile?

0 Answers  

---

How to create new tables with "select ... Into" statements in ms sql server?

0 Answers  

---

What is store procedure? When do you use?

0 Answers  

---

What is the fillfactor concept in indexes?

0 Answers  

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---