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

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

0 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


Which sql server is best?

0 Answers  


What is statement level trigger?

0 Answers  


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

0 Answers  






What is raid, and how it can influence database performance?

0 Answers  


What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,


What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,


How do I view a trc file?

0 Answers  


What are the advantages of user defined function?

0 Answers  


Different Types of Functions ?

2 Answers   Satyam,


What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  


Categories