SQL Server Interview Questions
Questions Answers Views Company eMail

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 3332

What is the maximun sixes of .mdf in sql server 2005

1 1897

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 2223

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?



what is isolation level at dead lock?



what r steps to we need to fallow b4 kill the process?


1 2738

If the job running very slow what is the action you do


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue


2 2822

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


Working with TLogs


How you trouble shoot when any job fails


How to trouble shoot if unable to connect SQL Server


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


Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Working with TLogs


your distribution database is full what will u do


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?


Issues related in upgrading SQL Server 2000 to 2005 / 2008


whats new about truncate in sql server 2008?


what is the sql equivaent of the dataset relation object ?


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?


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance


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


What is RMS migrations?


1 01 101 01010


what is checksum in sql server.........???