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 4339

What is the use of MOVE keyword in restore command

IBM,

3 3007

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

IBM, CarrizalSoft Technologies,

4 3502




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 2574

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 4750

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 1956

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 2043

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

Value Labs,

8 7331




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 3765

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 3597

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 2037

how to count datewise data in sqlserver

IndusInd Bank, CarrizalSoft Technologies,

4 10705

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 2069

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

247Customer,

11 6071

What is excution Plan in sql server

TCS, CarrizalSoft Technologies,

1 4288


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?

1197


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

1271


what is difference between view and Dip.

1165


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

815


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

772






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

792


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

852


What is Lock table in SQL?

225


If we delete pack Spec what will be the status of pack Body ?

147


Call by value and call by reference in procedure and function, with NOCOPY.

122


Tell about MOM Tool(Microsoft Operator Manager)?

652


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.

1573


Scalability, Availability, Integration with internet, etc.)?

1608


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?

589


how to do partition in sqlserver

1279