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


SQL Server Interview Questions
Questions Answers Views Company eMail

What is the difference between coalesce() & isnull()?

 530

What is the difference between local and global temporary tables?

 582

What is bcp? When does it use?

 511

What is the osql utility?

 537

Explain the steps needed to create a scheduled job?

 525

What are the types of joins in sql?

 562

What are orphan records?

 545

What have included columns when we talk about sql server indexing?

 574

List all the types of user-defined functions?

 520

Why use “nolock” in sql server?

 559

Explain primary key in sql server?

 565

What is the filtered index?

 559

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

 494

How will you go about resolving deadlocks?

 549

What is the difference between osql and query analyzer?

 543

Un-Answered Questions { SQL Server }

What is the new security features added in sql server 2014? : sql server security

565

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

602

In what three ways is the return statement used in a stored procedure?

514

How to create a view using data from another view?

564

what do you understand by change data capture?

558




How does a profiler work?

512

Name few endpoints exposed by ssrs 2012?

303

What are basics of policy management?

606

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

600

Why do you want to join software field as you have done your BE in Electronics?

1701

What is bcp? When does it use?

511

Write a program using SQL queries to find a unique entry in a table.

540

How to define the name and server for a new dsn?

547

How to use transact-sql statements to access the database engine?

537

What is for xml in sql server?

536

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