SQL Server Interview Questions
Questions Answers Views Company eMail

What are the different types of sub-queries?

594

How to choose all records from the table?

644

What is an index. What are the types?

576

What happens on checkpoint?

606

Distinguish between nested subquery and correlated subquery?

539

Define synonym?

724

What are the different ways you can create databases in sql server?

562

How many null values we can have in a unique key field in sql server?

543

How would we use distinct statement? What is its use?

596

What are scalar functions in sql?

599

What are distinctive joins find as a part of sql?

548

What are diverse clauses that form a part of sql?

591

Define primary key?

650

What is the distinction amongst delete and truncate?

579

What are the diifferences between the ms sql server vs mysql?

642


Un-Answered Questions { SQL Server }

How you can add messages to the nt event log from within a stored procedure?

561


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

475


How to select an exiting database using mssql_select_db()?

505


How many types of triggers are there?

563


Where can you add custom error messages to sql server?

575






As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

614


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

545


What is RMS migrations?

1694


What is difference in performance between insert top (n) into table and using top with insert?

526


How to write an inner join with the where clause in ms sql server?

545


What are SSL and TSL protocols?

577


What is the benefit of normalization?

581


How to create and drop temp table in sql server?

580


what is the sql equivaent of the dataset relation object ?

1561


Where are stored procedures in sql server?

556