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?

 581

What is bcp? When does it use?

 511

What is the osql utility?

 536

Explain the steps needed to create a scheduled job?

 525

What are the types of joins in sql?

 561

What are orphan records?

 545

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

 572

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?

 541

Un-Answered Questions { SQL Server }

Explain the architecture of ms sql reporting service?

526

What is the difference between DataRow.Delete() and DataRow.Remove()?

731

explain databases and sql server databases architecture? : Sql server database administration

519

Explain security with sql azure?

161

Why are sql functions used?

618




List all types of constraints in sql server?

511

Explain transaction server isolation?

544

What are filegroups in sql server?

581

What is an sql server agent?

545

What are the disadvantages of using querystrings to send data from one page to another?

584

What is filter index?

516

Explain what are partitioned views and distributed partitioned views?

579

What are the reporting services components?

92

How to check if stored procedure is running in sql server?

481

Explain the purpose of indexes?

542

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