SQL Server Interview Questions
Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 8292

What is difference between restoration and recovery in SQLServer?


3 8213

Why we need to use secondry database file? though, we can do same work using primary database file also.


2 4301

What is difference between process and thread? Explain lazy writer funcationality.


2 5530

What is live lock and deadlock? what is Lock escalation?


2 5832

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?


1 2675

What is Primary key and foreign key? Give an example


4 6237

How to connect PK and FK?

2 3698

What is the SQL?????????????????????????????


5 4026

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i



what is an sql server?

1 2387

find 2nd highest salary of person using cursor concept?


6 5898

how to find the second salary?

HCL, Prithvi,

10 6553

How to swap the data of two columns in a table. both the columns containing varchar values.

9 11227

What are the steps need to be take improve the speed of a SQLDATA Server?


2 2991

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

your distribution database is full what will u do


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?


what are the critical issues you have resloved in your company


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?


Delete duplicate rows without using rowid.


application server is slow what may be the problem


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


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.


How you trouble shoot when any job fails


what is isolation level at dead lock?


can any body tell me how to know the password of current user in sql server


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


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


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?