SQL Server Interview Questions
Questions Answers Views Company eMail

what is difference between primary key and Unique

8 4006

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

SAP Labs,

3 6110


3 4336

what is cluster and nin-cluster index?

4 3447

how to delete duplicate rows from table in sql server


12 14447

What is difference beteen Migration and Upgrdation?


7 18517

What are different types of Keys? Please explain all the keys with a suitable example.

4 23014

What is cursor ? And what is difference between Trigger ?

HCL, Polaris,

2 24272

What is row by row processing ?

2 5747

can primery key be a non clustered index?

10 6740

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 3724

can foreign key take role of primary key?

TCS, CarrizalSoft Technologies, Villa Marie,

5 6019

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?


4 6257

How to find out name of all employees who has salary less than 200 Rs.?

8 4379

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 1966

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

ow to bring suspect mode datbase online from scratch


how to use DTS package in 2000,2005,2008 in sql server


If user is owning any SQL Objects, can we drop that user


What is data modeling and Reterminal integrity?


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


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


tell me the disaster recovery plan


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?


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


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


Why do you want to join software field as you have done your BE in Electronics?


how can u get last observation in an unknown dataset ?


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


query processing