SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How get current date in SQL server 2000

Cap Gemini, Polaris,

4 6816

How get current date in SQL server 2000

Cap Gemini,

6 9385

In the primary key have a multiple field or not?

TCS,

8 9193

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

PMAM IT Services, TCS,

7 9819

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2019

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2005

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

NIIT,

3 6079

what are the critical issues you have resloved in your company

Wipro,

1957

how can you move the master database

IBM,

1 4700

What is RMS migrations?

Satyam,

2129

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

Brigade, Wipro,

9 11139

What is split brain scenario in DB mirroring?

1 11349

how do we insert 100 records at a time in a table without using for loop in database

1 4874

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 7858

in how many ways we can use count()

2 3734

Un-Answered Questions { SQL Server }

Do you know what is fill factor and pad index?

996

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

How to remove duplicate rows from table?

1241

Write a sql query to sort on different column name according to the parameters passed in the function?

895

Do you know nested transaction?

953

What is the use of sign function?

1113

What is page in sql server?

941

What is the sql server agent?

1083

What are the different editions available in sql server 2000?

1045

Tell me when is the update_statistics command used?

1102

What is exporting and importing utility?

1078

Can you always create a cache of a report?

172

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

912

What is updatable resultset?

999

What is the difference between lock, block and deadlock? : sql server database administration

1038

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