tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration


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

Post New Answer

More SQL Server Interview Questions

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  


Explain syntax for disabling triggers?

0 Answers  


What are SSL and TSL protocols?

0 Answers   Wipro,


How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,


What is the tcp/ip port on which sql server runs?

0 Answers  






what are the types of indexes? : Sql server database administration

0 Answers  


write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,


I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 Answers  


What is the difference between ddl,dml and dcl commands?

0 Answers   BirlaSoft, Verifone,


explain different types of constraints? : Sql server database administration

0 Answers  


Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,


Can we add our custom code in ssis?

0 Answers  


Categories