SQL Server Interview Questions
Questions Answers Views Company eMail

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 4190

What is BCP? When do we use it?

2 7997

What should we do to copy the tables, schema and views from one SQL Server to another?

3 6001

What are the different types of joins and what does each do?

2 5839

What is a sub-query? When would you use one?

3 10990

What are three SQL keywords used to change or set someone?s permissions?

3 11607

What is referential integrity? What are the advantages of it?

Descon, Digital Domain,

4 24045

What is database normalization?


7 11802

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?


5 12400

What is a trigger?

7 4206

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

Merrill Lynch, Wipro, Accenture,

2 9656

What is an execution plan? When would you use it? How would you view the execution plan?

1 4113

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 8082

What are the different types of replication? How are they used?

3 9108

What is the difference between a local and a global variable?

5 33860

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?


How can we call UDF(User Define Function) using C# code in ASP.net ?


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that


New concepts of sql server 2005 use in your project.


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60


Call by value and call by reference in procedure and function, with NOCOPY.


wat wil hapn if we give the both read and deny read permission to user?


where the connection string store in the database


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


What is RMS migrations?


Delete duplicate rows without using rowid.


Tell about MOM Tool(Microsoft Operator Manager)?


how can you attach more than 20 ldf files in sql server


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?