Answer / guest

The pros are that you can implement additional
functionality and access data from DLLs from within SQL
Server. If you need to do something that can be done only
in C or C++, or if you have data that can be accessed only
outside of SQL Server, you can still provide a link to it.
The biggest con to extended stored procedures is that they
run in the same process space as SQL Server. So an errant
DLL could overwrite memory and cause SQL Server to crash or
even corrupt data. The biggest safeguard against these
problems is thorough testing of the procedure

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

Can we create clustered index on composite key?

0 Answers  

---

What are the two authentication modes in sql server?

0 Answers  

---

Define Joins?

0 Answers   HCL,

---

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

How many categories of data types used by sql server?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

Why olap is used?

0 Answers  

---

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers  

---

What is filter index?

0 Answers  

---