How to optimize stored procedures in sql server?


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

Post New Answer

More SQL Server Interview Questions

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  


Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  


What is instead of trigger sql server?

0 Answers  


What is pessimistic concurrency?

0 Answers  


What is primary key and example?

0 Answers  






What are the parts of a function?

0 Answers  


how can i view structure of table in sql server? tell me that query.

10 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


What is the boxing and unboxing concept in .net?

0 Answers  


How will you decide the active and passive nodes?

0 Answers  


Why do we use trigger?

0 Answers  


if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  


Categories