How many non clustered indexes there can be on table ?

514

State the difference between union and union all?

523

How can you tell if a database object is invalid?

619

How to change the system date and time from SQL Plus Terminal ?

689

Do you know what is a trace frag? Where do we use it?

560

Explain external key management in sql server 2008

506

What different steps will a sql server developer take to secure sql server?

508

How do I find the port number for sql server?

506

What are the purposes of floor and sign functions?

544

How to create stored procedures with parameters in ms sql server?

529

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

568

Define constraints and give an example of their use?

565

How to modify an existing stored procedure in ms sql server?

541

What is #table in sql server?

539

How to create a ddl trigger using "create trigger" statements?

618