SQL Server Interview Questions
Questions Answers Views Company eMail

Explain about temporary stored procedure?

512

Define right outer join in sql server joins?

508

Explain features of analysis services?

511

What is the stuff?

519

Explain about remote stored procedure?

579

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

506

What are the differences between lost updates and uncommitted dependencies?

531

Explain the different index configurations a table can have?

496

How do clustered indexes store data?

599

How to create nested stored procedure?

533

Explain the truncate command?

511

How does stuff differ from the replace function?

542

What's the information that can be stored inside a bit column?

532

What is the use of custom fields in report?

550

What is bit data type?

608


Un-Answered Questions { SQL Server }

How to return the top 5 rows from a select query in ms sql server?

579


Explain the xml support sql server extends?

607


What are triggers? How do you invoke a trigger on demand?

735


What is the log shipping?

572


What is the difference between locking and multi-versioning?

517






Why do we need different type of parameter?

543


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

5488


Do you know the different ddl commands in sql?

580


What is sql server locking?

542


What is a mutating table error and how can you get around it?

527


how many triggers you can have on a table? : Sql server database administration

482


What is an identity?

559


How to find the second highest salary of an employee?

578


How to create user defined functions with parameters?

628


How do I install only the client tools of sql server 2000?

537