what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How will you find out if there are expensive SQL statements running or not?
What are null values in ms sql server?
What are the disadvantages of primary key and foreign key in SQL?
What is sql service broker?
How dts is used to extract, transform and consolidate data?
how will add additional conditions in sql?
How to replace null values in expressions using isnull()?
What is the maximum number of index per table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are joins in sql and what are the different types of joins?
How does index makes search faster?
What are key constraints?
what is dbcc? : Sql server database administration
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?