SQL Server Interview Questions
Questions Answers Views Company eMail

what is the query and condition to delete datas in sql server.

2 2526

How do you fine the performance tunning?


2 5112

what is diffence between replicaion and logshipping?

1 2407

what is physical sort data and logical sort data in index?

2 4560

When do you create cluster and noncluster index?


5 5864

how can do you the system monitoring?

1 4798

what is the Enterprise manager(2000) and management studio (2005)?

2 2543

How the data stores in a page?

1 2492

what are the problems in logshipping?

3 17822

How to tune a stored procedure?

6 12060

what is index seek and index scan?

2 9206

What is the difference between IN and EXISTS operators in SQL Server?

CSC, Intelligroup, ASD Lab,

9 56841


HCL, Intelligroup,

2 3714

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 3288

can you any body tell me the difference between candidate key and primary key

4 4435

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

how can u get last observation in an unknown dataset ?


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.


1 01 101 01010


New concepts of sql server 2005 use in your project.


System variable and temporary variables


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


How to trouble shoot if unable to connect SQL Server


Tell about MOM Tool(Microsoft Operator Manager)?


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


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.


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?


How retrieve field names from the table in SQL through JAVA code?


what are the Prerequisites for Replication?


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A