What is the difference between a unique key and primary key?

1002

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1144

How to use column default values in insert statements in ms sql server?

1097

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1724

What you can do to delete a table without the delete trigger firing?

1012

Can you get second highest salary from the table?

1006

Explain about SQLOS?

1057

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2568

Explain what is public role in sql server?

1188

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1049

Explain contrast amongst grouped and non-bunched records?

1087

Explain multiserver query

1110

What is the difference between web edition and business edition?

113

what is checksum in sql server.........???

1744

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?

1191