Answer / kinthada cnu

hi all

Trigger nothing but special kind of stored procedure
it's providing security to table data.And it is automatically
fire when the queary excuted.

ex:
create trigger <trigger name>
on <table name>
for <insert/update/delete>
as
begin
<statments>
end

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

Describe in brief sql server monitoring ways.

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

How many index keys possible for a table

6 Answers  

---

Which autogrowth database setting is good?

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What is the purpose of grouping data in a report?

0 Answers  

---

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

---

Which is better statement or preparedstatement?

0 Answers  

---

What is use of dbcc commands?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---