Infosys interview : (18/7/2010)
Dynamic Management Views (DMV)
Diff b/n SP and Trigger
Profiler – [get the db id from sys.databases] LoginUser, SPID, Query Text
DB tuning Advisor – How apply recommendations- By clicking on Apply Button.
It applies statistics to the table for a column.
Statistics in SQL Server
A Sp is taking 45min to execute
How do improve the performance for this SP
— Firstly look for joins and remove unnecessary columns in select statement
— See the execution plan and analyse where the more cost is taking
— If possible try to create indexes and again see the performance
— If it is an OLTP database, create a view with index
What are the enhancements provided in SQL 2008 at performance level.
What are the tasks done by you in SSIS (Integration Services)
difference between Trigger and Check Constraint
How many system databases are there and what does each db do
Advantages of View
Types of Trigger
How do u enable paging for a grid with improved performance.