What are sql servers used for?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

What is exporting utility?

0 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

How many primary keys are possible in a table?

0 Answers  

---

Do you know what are the steps to process a single select statement?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What is a partition function in sql server?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

Differentiate between sql temp table vs table variable?

0 Answers  

---