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?

1055

How will you find out if there are expensive SQL statements running or not?

1015

What are null values in ms sql server?

1088

What are the disadvantages of primary key and foreign key in SQL?

1116

What is sql service broker?

982

How dts is used to extract, transform and consolidate data?

1073

how will add additional conditions in sql?

1104

How to replace null values in expressions using isnull()?

1101

What is the maximum number of index per table?

1073

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?

1139

What are joins in sql and what are the different types of joins?

1014

How does index makes search faster?

979

What are key constraints?

976

what is dbcc? : Sql server database administration

1033

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

950