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 12493

How to get max 100 values from sql server

7 13607

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

CarrizalSoft Technologies, DELL, SoftSol,

7 11937

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 5198

To find second largest salary in Employee table

CSS,

17 20900

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

2085

How can we Use Linked Server? Uses of Linked server

IBM,

1 5667

What are the Pre Requisites when you apply Srvice Packs?

IBM,

1 4370

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

IBM,

2 8815

What is Trace flag?

Wipro,

1 4685

Differences between Standby Vs No recovery?

Wipro,

2 16884

what is lazy writer?

Wipro,

1 8900

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

Wipro,

1 7295

What is the use of Port no?

Wipro,

1 4831

Can you explain some of the DTS problems?

UBS, Wipro,

1 4899

Un-Answered Questions { SQL Server }

What are distributed partitioned views?

1137

What is store procedure?

1118

how would you troubleshoot blocking? : Sql server database administration

1027

How to list all tables in the database using odbc_tables()?

1123

Can you pass expressions to stored procedure parameters?

1088

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1120

Can sql servers link to other servers like oracle?

898

How can you manage sql azure security?

105

How to truncate the log in sql server 2012? : sql server database administration

1350

What is sleeping status in sql server?

1080

What is difference between table aliases and column aliases? Do they affect performance?

1021

Define candidate key, alternate key, and composite key.

969

explain databases and sql server databases architecture? : Sql server database administration

1017

What is user-defined function?

1035

What is the library index called?

1115

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