Infosys interview : (18/7/2010)
Database Design 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 Row_Number function
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 Table Partitions Types of Trigger
.Net How do u enable paging for a grid with improved performance.