Answer Posted / amar_chhatwani

ir returned Int datadtpe

Explain how dts is used to extract, transform and consolidate data?

768

---

What is the use of @@spid?

749

---

Which are ddl commands?

710

---

When you use @@error and try-catch?

766

---

Explain view in sql server?

822

---

What is a livelock?

723

---

What is built-in function?

708

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

680

---

Explain different types of locks in sql server.

778

---

Why should one not prefix user stored procedures with ‘sp_’?

810

---

How to use “drop” keyword in sql server and give an example?

865

---

Write a sql query to delete duplicate records from a table called table1

784

---

Does an index slow down updates on indexed columns?

720

---

What do you understand by mirroring and mention the advantages of the mirroring?

796

---

Can sql servers linked to other servers like oracle?

705

---