SQL Server Interview Questions
Questions Answers Views Company eMail

What do u mean by orphan users, how will u list them in the DB

IBM,

2 4463

What is the use of MOVE keyword in restore command

IBM,

3 3127

How will u find the query which is running in some other machine

IBM, CarrizalSoft Technologies,

4 3601




What is the role that is required for killing a process What is the role that is required for creating a linked server

IBM, CarrizalSoft Technologies,

1 2671

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

IBM, CarrizalSoft Technologies,

3 4864

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 2029

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 2116

How to get the count of distinct records. Please give me the query?

Value Labs,

8 7569




Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

Value Labs,

4 4004

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

247Customer,

3 3741

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 2128

how to count datewise data in sqlserver

IndusInd Bank, CarrizalSoft Technologies,

4 11023

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 2167

please tell me the query to get details of the employee having the second largest salary

247Customer,

11 6357

What is excution Plan in sql server

TCS, CarrizalSoft Technologies,

1 4397


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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., }

1088


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

432


What is best institute to Learn DotNET And SQL in chennai?

1006


application server is slow what may be the problem

1115


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

935






What is Lock table in SQL?

311


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?

657


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1289


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

707


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

1385


How do you Implement SSIS Packages in your Project?

869


tell me the disaster recovery plan

1325


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

701


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

1081


how many no of arguments can be passed in procedures and functions

3558