SQL Server Interview Questions
Questions Answers Views Company eMail

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

Indecomm,

7 3550

write a query to remove duplicate records without using primary key column?

ABCO,

2 6471

What Is The Difference Between Primary Key & Super Key

Accenture,

3 4351




I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

Wipro, HCL,

1102

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 4464

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 3018

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

872

what is Equity join?

ADP,

2 3816




How to get number of days in a given year?

ADP,

4 3610

Differencr Between DELETE and TRUNCATE?

ADP,

3 3901

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

ADP,

2 3004

How to get number of days in a given year?

ADP,

4 4624

Explain SELF JOIN ?

ADP,

3 3894

What is Index ? Explain its Types?

ADP,

2 4775

Define Foreign Key?

ADP, College School Exams Tests,

3 5444


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

671


SQL Server Architecture ?

1133


what exactly sql injuction.how to overcome.....

1311


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.

2680


whats new about truncate in sql server 2008?

1310






optimization techinques

1330


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


Tell about MOM Tool(Microsoft Operator Manager)?

681


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4769


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

939


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

1333


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

858


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

1253


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

863


What is the difference between online clustering and Offline clustering?

1227