SQL Server Interview Questions
Questions Answers Views Company eMail

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 3403

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 4120

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 3070




Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 3721

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 2111

Write a query to get all details of employee who has maximum salary from employee table

Genpact, AON,

8 9251

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

Broadridge,

5 6576

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.

HCL,

1235




Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

HCL, Cognizant, Value Labs,

1 5401

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 4777

what is the difference between table and view

1 1438

plss anybody specify tha constrian management system in dbms

Police Constable,

788

How to genrate automaticlly empid like gt001

4 2467

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 4005

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

L&T, IBM,

3 3520


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?

1197


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

899


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

641


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

828


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.

1235






Delete duplicate rows without using rowid.

155


how can you attach more than 20 ldf files in sql server

800


role of sql sever 2005 in database rather than any other database

855


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

792


what are the critical issues you have resloved in your company

789


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

831


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1544


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


how to take backup bcp out for a column in table in sql server?

820


tell me the disaster recovery plan

1260