1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

What is isnull() operator?

 680

What is coalesce in sql server?

 631

What is the use of set nocount on/off statement?

 704

What are the differences between stored procedure and the dynamic sql?

 663

How to delete duplicate rows in sql server?

 660

What will be the maximum number of index per table?

 648

What is the use of =,==,=== operators?

 678

How data can be copied from one table to another table?

 590

How can we get count of the number of records in a table?

 613

What is the purpose of floor function?

 638

What is tablesample?

 665

What are the differences between local and global temporary tables?

 648

What is the command used to recompile the stored procedure at run time?

 698

What are the methods used to protect against sql injection attack?

 689

Can sql servers linked to other servers?

 633

Un-Answered Questions { SQL Server }

What is the purpose of linked server configuration in sql server?

631

What is tempdb database? : SQL Server Architecture

681

Which is faster statement or preparedstatement?

618

What are the advantages of partitioning?

742

Explain atomicity?

652




Tell me the difference between clustered and non-clustered index?

597

What is scan table/view and seek table/view when its occurs? : sql server database administration

606

How can you start sql server in different modes?

608

Explain the various types of concurrency problem?

805

Explain insert into select statement?

599

Can a database be shrunk with users active?

697

Explain full-text query in sql server?

618

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

693

How can you list all the table constraints in a database?

601

what authentication modes does sql server support? : Sql server database administration

616

For More Un-Answered { SQL Server } Questions Click Here