SQL Server Interview Questions
Questions Answers Views Company eMail

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2


5 4979

what is the difference between group and having give an example with query and sample output

7 4886

What is Data model and how to prepare a data model.?


1 3627

what is a stored procedure and trigger?

3 2610

How to retrieve data from log files in SQL SERVER ?????

1 4518

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 6835

Whether the updations made to the views reflect the original records in the table


5 5668

How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?

3 3034

how to select 5 to 7 rows from a table, which contains 10 rows?


21 12249

How to select nth record from a table?

Ramco, Microsoft, DELL,

13 25190

role of sql sever 2005 in database rather than any other database


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



Which is the best place or learning center for MS SQL?????In Bangladesh?????

TCL, Wipro,


what is the difference between Delete and Truncate

Geo Research Centre, CarrizalSoft Technologies,

4 4603

from the table display the 2nd highest salary? and also the least 2nd salay?

8 5092

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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


application server is slow what may be the problem


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


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?


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 .


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }


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


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.


plss anybody specify tha constrian management system in dbms


how can u get last observation in an unknown dataset ?


what is isolation level at dead lock?


How do use Having,Group by,Group function in SQL?


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


Does any body please help me what question's have asked for SSRS in the interview?