OPTIMIZATION OF SP,CURSOR,TRIGGERS


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Can you explain important index characteristics?

0 Answers  


How to find the login name linked to a given user name?

0 Answers  


Explain Capacity planning to create a database? and how to monitor it?

0 Answers  


What is coalesce in sql server?

0 Answers  


How will u test the stroded procedures and functions? difference between SP and Triggers

2 Answers   TCS,






How to update a field in SQL after ALTERING a row?

0 Answers   Amdocs,


Explain use of expression builder.

0 Answers  


What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

0 Answers  


List down some advantages of sql stored procedure?

0 Answers  


Explain “@@rowcount” and “@@error” in sql server?

0 Answers  


can a database be shrunk with users active? : Sql server administration

0 Answers  


Explain how many types of relationship?

0 Answers  


Categories