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 6985

How get current date in SQL server 2000

Cap Gemini,

6 9611

In the primary key have a multiple field or not?

TCS,

8 9454

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 10035

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 ?

2076

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

2075

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 6197

what are the critical issues you have resloved in your company

Wipro,

2016

how can you move the master database

IBM,

1 4791

What is RMS migrations?

Satyam,

2190

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 11414

What is split brain scenario in DB mirroring?

1 11477

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

1 4938

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 8114

in how many ways we can use count()

2 3839

Un-Answered Questions { SQL Server }

What are different replication agents and what's their purpose? : sql server replication

1053

List out different types of normalizations in sql server and explain each of them?

971

how you can list all the tables in a database?

1067

Is it ok to shrink transaction log?

1051

Can a table be created inside a trigger?

1012

What is the New in SQL server 2008?

1015

What is the size of transaction log file?

985

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

996

Explain cross join or cartesian product in sql?

927

Explain the disadvantages of cursors?

1205

What is 1nf 2nf and 3nf?

954

What is stretch database in sql server?

1118

What is nonclustered index on computed columns?

995

what method you can use to reduce the overhead of Reporting Services data sources?

268

How to use order by with union operators in ms sql server?

1063

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