SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 2656

How do you fine the performance tunning?

Accenture,

2 5358

what is diffence between replicaion and logshipping?

1 2527




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

2 4814

When do you create cluster and noncluster index?

Satyam,

5 6063

how can do you the system monitoring?

1 5063

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

2 2674

How the data stores in a page?

1 2711




what are the problems in logshipping?

3 18284

How to tune a stored procedure?

6 12290

what is index seek and index scan?

2 9438

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

CSC, Intelligroup, ASD Lab,

9 57670

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 3858

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

2 3442

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

4 4631


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

which backup strategy you are following at ur company

992


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

831


What is the difference between NOROW and LOCKROW?

1292


application server is slow what may be the problem

1084


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

655






Does any body please help me what question's have asked for SSRS in the interview?

858


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.

705


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.

1618


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

779


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

595


Why we need to use secondry database file? though, we can do same work using primary database file also.

4213


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

313


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


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

671


what are the critical issues you have resloved in your company

822