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 4227

What is BCP? When do we use it?

2 8023

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

3 6029




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

2 5874

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

3 11064

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

3 11732

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

Descon, Digital Domain,

4 24310

What is database normalization?

Digicel,

7 11874




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

eFunds,

5 12468

What is a trigger?

7 4267

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 9885

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

1 4172

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

2 8175

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

3 9263

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

5 34114


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

789


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

870


how to take backup bcp out for a column in table in sql server?

820


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1072


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

1016






Tell about MOM Tool(Microsoft Operator Manager)?

651


tell me the disaster recovery plan

1260


You are doing log shipping due to some reasons it is failing. How you will proceed from there

792


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2649


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

563


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1472


Explain Capacity planning to create a database? and how to monitor it?

2742


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

835


what is package and it uses and how can u call a package

851


what is difference between view and Dip.

1165