SQL Server Interview Questions
Questions Answers Views Company eMail

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 5871

whats new about truncate in sql server 2008?

Serco, MedSave Healthcare,

1301

ow to bring suspect mode datbase online from scratch

677




1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

771

wat new abt truncate in sql server

HP, HCL,

2 3842

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

Microsoft,

766

on line cluster can we make if yes tell me the procedure

Microsoft,

826

which backup strategy you are following at ur company

977




your distribution database is full what will u do

944

Differences between logshipping and mirroring

Syntel, Microsoft,

1 3252

tell me the disaster recovery plan

Microsoft,

1273

application server is slow what may be the problem

Microsoft,

1072

Define the term DML, DDL and DTL?

1 21663

Creating Tables Using SELECT

1 1653

How can I create a table from another table without copying any values from the old table?

3 2842


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

864


New concepts of sql server 2005 use in your project.

1224


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

585


what is the Ticketing tool used in Wipro technologies at Bangalore...???

4961


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

927






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

1027


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

1048


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

953


whats new about truncate in sql server 2008?

1301


System variable and temporary variables

969


How much memory that we are using in Logshipping Concept?

685


How do you Implement SSIS Packages in your Project?

821


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1334


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

864


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1131