Answer Posted / sajid equbal

explorer

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1005

---

How to create a new schema in a database?

1147

---

What is dknf in normalization form?

1052

---

Explain the difference between HTTP and HTTPS in database?

1030

---

Will the writetext statement activate a trigger?

1093

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1051

---

What is the parse query button used for?

1038

---

How does Report Builder support Analysis Services cubes?

153

---

What area unit the various kinds of info compression introduced in sql server 2008?

1077

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

984

---

How does normalization work?

917

---

what is datawarehouse?

1110

---

Do you know clustered and non-clustered index?

977

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

997

---

Can two tables have the same primary key?

1204

---