Answer Posted / awi (focus)

count(*) return Int Data Type

How important do you consider cursors or while loops for a transactional database?

907

---

What is the difference between migration and upgradation in sql server?

1037

---

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

917

---

Can we take the full database backup in log shipping?

898

---

Do you know sql server 2008 introduces automatic auditing?

901

---

Explain differences between web edition and business edition?

119

---

Is it ok to shrink transaction log?

935

---

What is a trigger? Why we need it?

940

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

984

---

Mention the different types of triggers?

1004

---

What is the recovery model? List the types of recovery model available in sql server?

839

---

what are the different types of replication you can set up in sql server? : Sql server database administration

968

---

Why I am getting this error when renaming a database in ms sql server?

985

---

What is cube dimension? : sql server analysis services, ssas

954

---

What are the source of constraints?

857

---