SQL Server Interview Questions
Questions Answers Views Company eMail

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 13029

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 1816

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

Deloitte, Lason,

9 18236




A left outer join B B right outer join A gives the same result then what is the use of two?

1 3483

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 6118

event classes in sql server

Accenture, AFE,

2 4587

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

L&T, CarrizalSoft Technologies,

4 7399

what is macro?

Wipro, Excel, Global Innovation,

5 8585




After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

942

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 3113

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 9862

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 6630

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 3868

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 12262

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 8809


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?

869


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?)

744


wat wil hapn if we give the both read and deny read permission to user?

976


What is RMS migrations?

989


How to convert a table data in XML format in sql server?

1440






how can u get last observation in an unknown dataset ?

1192


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

884


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?

908


your distribution database is full what will u do

995


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

906


What is the difference between online clustering and Offline clustering?

1259


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

965


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

899


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1529


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

860