How to view existing indexes on an given table using sys.indexes?

594

What is correlated subquery in sql server?

557

What are date and time data types in ms sql server?

526

What is triggers and stored procedures?

512

Explain different types of locks in sql server.

596

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

545

List out different types of normalizations in sql server and explain each of them?

555

How to find the login name linked to a given user name?

530

What is full outer join in sql server joins?

565

How do you delete a data source?

541

Why do we need different type of parameter?

548

State the difference between union and union all?

519

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

551

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

528

How do you send email on SQL Server?

580