SQL Server Interview Questions
Questions Answers Views Company eMail

wat is the main diff between sql server 2000and sql server 2005

Jade Software,

6 8432

What is the difference between windows authentication and sql server authentication

HCL,

7 21480

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

IGT,

1745

how can i store resumes in database?

HCL,

3 8795

how many joins we can write if at all we have n no of tables

Tanla Solutions, TS,

5 14338

what is the order of execution of where,having,group by in select stement

IBM, Tanla Solutions,

6 20378

What is the difference between SSAS 2000 and SSAS 2005?

APX,

1 6551

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

APX,

6 12995

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 9440

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

Google,

15 13173

i want table name basis on column name.

5 6714

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

iFlex,

3 6794

In clustered and non clustered indexes which one is faster while executing a query ?

1 6913

How to create logins using windows Authentication mode?

2 3735

write the query for taking database restore in sql?

2 4617


Un-Answered Questions { SQL Server }

How do triggers work?

528


Explain stored procedure?

588


What is de-normalization and what are some of the examples of it?

522


You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

557


Explain what is row_number function?

546






What are SSL and TSL protocols?

571


What is the command used to check locks in microsoft sql server?

532


What is triggers and stored procedures?

506


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1390


How to connect to a sql server using odbc_connect()?

607


Tell me what is log shipping?

556


How do you identify a foreign key?

590


What Is Rdbms?

663


What is the difference between varchar and nvarchar datatypes?

561


What is federation member?

91