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

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 12241

How to get max 100 values from sql server

7 13366

What are the factors you will check for the performane optimization for a database query?

CarrizalSoft Technologies, DELL, SoftSol,

7 11647

I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,

2 5116

To find second largest salary in Employee table

CSS,

17 20339

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2019

How can we Use Linked Server? Uses of Linked server

IBM,

1 5584

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4309

What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

IBM,

2 8712

What is Trace flag?

Wipro,

1 4623

Differences between Standby Vs No recovery?

Wipro,

2 16702

what is lazy writer?

Wipro,

1 8811

Can we move Resource database from one path to another? If yes,How can we?

Wipro,

1 7206

What is the use of Port no?

Wipro,

1 4740

Can you explain some of the DTS problems?

UBS, Wipro,

1 4805

Un-Answered Questions { SQL Server }

What is scheduled job and how to create it?

982

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

Write an sql query for deleting duplicate rows?

995

What are window functions in sql server?

1004

What do you understand by hotfixes and patches in sql server?

985

How to create an identity column?

1215

Is there any difference between the primary key and unique key?

999

What is the difference between push and pull subscription? : sql server replication

1211

Which data type columns are the best candidates for full-text indexing?

965

Explain the concept of recursive stored procedure.

945

How to execute the cursor queries with "open" statements?

1178

Explain system functions or built-in functions? What are different types of system functions?

971

Is sql server is free?

974

How do you check sql server is up and running?

995

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

999

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