Answer Posted / navneet sharma

IN work like a OR in sql query but in is faster than OR in
case of IN server will search whole table
EXISTS is use to find the required row and does not search
whole table

Write a program to fetch first 10 records from a file?

994

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

987

---

What are data resources?

901

---

Explain about analysis services?

1043

---

What is the function of sql server agent windows service?

1077

---

How to use copy and concatenate commands in SQL?

1128

---

How to delete multiple rows with one delete statement in ms sql server?

991

---

What is logshipping and its purpose?

980

---

How will you know when statistics on a table are obsolete?

1070

---

What is a field in a table?

1030

---

Explain how you can deploy an SSRS report?

146

---

What is an execution plan? When would you use it?

967

---

How to grant a permission in ms sql server using "grant execute" statements?

1076

---

What is the process of indexing?

997

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

944

---