SQL Server Interview Questions
Questions Answers Views Company eMail

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

2 2694

How do you fine the performance tunning?

Accenture,

2 5395

what is diffence between replicaion and logshipping?

1 2545




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

2 4862

When do you create cluster and noncluster index?

Satyam,

5 6113

how can do you the system monitoring?

1 5115

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

2 2694

How the data stores in a page?

1 2744




what are the problems in logshipping?

3 18360

How to tune a stored procedure?

6 12341

what is index seek and index scan?

2 9475

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

CSC, Intelligroup, ASD Lab,

9 57824

What about UPDATESTATISTICS ?

HCL, Intelligroup,

2 3888

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

2 3461

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

4 4685


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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.

1364


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1061


what are the critical issues you have resloved in your company

838


What is the difference between online clustering and Offline clustering?

1240


What is RMS migrations?

970






How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

628


How can we call UDF(User Define Function) using C# code in ASP.net ?

4710


your distribution database is full what will u do

968


what is checksum in sql server.........???

411


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.

1640


last function used in MS Access to convert sql what function will use in sql

865


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

1167


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2720


Delete duplicate rows without using rowid.

208


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

672