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?

Digicel,

7 11802




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

eFunds,

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?

789


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

4581


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

998


New concepts of sql server 2005 use in your project.

1188


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

876






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

99


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

889


where the connection string store in the database

757


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

4686


What is RMS migrations?

902


Delete duplicate rows without using rowid.

135


Tell about MOM Tool(Microsoft Operator Manager)?

634


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

781


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

318


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

2579