Interview Questions

Infosys interview : (18/7/2010)
Database Design Dynamic Management Views (DMV)
Diff b/n SP and Trigger
Performance Tuning.
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.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: