SQL Server Interview Questions
Questions Answers Views Company eMail

What do mean by xml datatype?

700

What is the difference between commit and rollback?

589

How exceptions can be handled in sql server programming?

624

How global temporary tables are represented and its scope?

634

Which sql server table is used to hold the stored procedure scripts?

701

What is subquery? Explain the properties of a subquery?

595

What do you mean by tablesample?

733

what is memory-optimized nonclustered indexes

649

What are different types of table joins?

650

How to delete duplicate rows?

623

What is transact-sql ddl trigger?

721

What is read committed?

685

How do we know if any query is retrieving a large amount of data or very little data?

635

What is the maximum size per database for sql server express?

634

What are basics of policy management?

724


Un-Answered Questions { SQL Server }

How to add code to the existing article (using improve article)?

684


Define full outer join?

604


How do I setup a local sql server database?

618


What is difference between join and natural join?

560


Who is the owner of a schema in ms sql server?

627






Explain the cursor lock types?

642


Why should one not prefix user stored procedures with ‘sp_’?

695


Why are sql functions used?

688


Mention the differences between sql server and mysql.

583


how to overcome kernel isssues

1269


How to remove duplicate rows from table?

711


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5585


How to update muliple row in single query?

711


How to connect a database with sql express.?

665


Explain what is it unwise to create wide clustered index keys?

609