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 12264

How to get max 100 values from sql server

7 13392

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

CarrizalSoft Technologies, DELL, SoftSol,

7 11675

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 5124

To find second largest salary in Employee table

CSS,

17 20385

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

2026

How can we Use Linked Server? Uses of Linked server

IBM,

1 5593

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 8717

What is Trace flag?

Wipro,

1 4626

Differences between Standby Vs No recovery?

Wipro,

2 16713

what is lazy writer?

Wipro,

1 8818

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

Wipro,

1 7208

What is the use of Port no?

Wipro,

1 4746

Can you explain some of the DTS problems?

UBS, Wipro,

1 4812

Un-Answered Questions { SQL Server }

What is log ldf?

983

Can a function call a stored procedure in sql server?

960

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1140

Delete duplicate rows without using rowid.

1532

What is a rownum?

976

Tell me what is difference between view and materialized view?

937

How to create an inline table-valued function?

977

What is use of dbcc commands?

1072

Can we store videos inside the sql server table?

980

Name 3 ways to get an accurate count of the number of records in a table?

1039

How to skip remaining statements in a loop block using continue statements?

998

What is self join in sql server joins?

1060

Which command is used for user defined error messages?

1060

Define Wed Edition in SQL Azure?

100

What is measure group, measure? : sql server analysis services, ssas

1013

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