What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

Do you know what is difference between stored procedure and user defined function?

0 Answers  

---

What is the recommended total size of your memory optimized tables?

0 Answers  

---

How to find index size for each index on table?

0 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

---

What is xml datatype?

0 Answers  

---

What are the hotfixes and patches in sql server?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---