What is the difference between a unique key and primary key?
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?
How to use column default values in insert statements in ms sql server?
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
What you can do to delete a table without the delete trigger firing?
Can you get second highest salary from the table?
Explain about SQLOS?
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.
Explain what is public role in sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain contrast amongst grouped and non-bunched records?
Explain multiserver query
What is the difference between web edition and business edition?
what is checksum in sql server.........???
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?