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


SQL Server Interview Questions
Questions Answers Views Company eMail

what is the disadvantage of SQL Loder?

TCS,

1 6063

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

TCS,

7 9848

what is difference between Enterprise Manager and Query Analyer

CTS,

6 7682

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

Synergy,

1 5591

what is DTS what are tasks available

Wipro,

1 3022

Normalization and denormalization

Wipro,

3 5559

Diffrent types of function

Wipro,

1 3842

diffrence between function and procedure

Wipro,

5 5750

diffrence between Cluster Index and non Cluster Index

Wipro,

3 5067

System variable and temporary variables

Wipro,

1696

optimization techinques

Wipro,

2183

user defined datatypes

Wipro,

1 3878

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

 1456

Magic Tables ?

Thomson Reuters,

2 5293

Diffrences between sql server 2000 vs 2005

Thomson Reuters,

2 4186

Un-Answered Questions { SQL Server }

Explain unique key in sql server?

528

Explain filtered indexes benefits?

584

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

654

Do you know what is a with(nolock)?

590

How to specify the collation for a character data type in ms sql server?

537




Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

646

What is use of dbcc commands?

616

Explain what is use of dbcc commands?

500

What are built in functions?

564

How to write a query with a left outer join in ms sql server?

562

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

96

How to assign new column names in a view?

497

What do you understand by triggers?

512

What are the disadvantages of merge replication?

757

How can we improve performance by using SQL Server profiler?

562

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