SQL Server Interview Questions
Questions Answers Views Company eMail

what is Constraint? How many types of constraints in SQL ?

IBM, HCL, Wipro, NIIT,

38 62549

How to write a script for upate the data in prod , i have 50000 row are there


2 3138

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.


my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 1435

what is advantages in sql 2005 over sql 2000?

4 4713

Any one plz send me SQL Server Developer/DBA resume for 4 years experience


Differnce between sel server 2000 and 2005

3 3494

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 3307

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7115

difference between sql server2000 and sql server2005


1 3359

Why Do you want to work in this company?


4 3697

i need some interview questions on sql server developer plz any onee send some links.

2 3507

what is mean by crystal repoart? ahere we will mainly use that?

1 2359

how to rename the table

3 3891

how many type of subquery?

2 4748

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

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.


what is the sql equivaent of the dataset relation object ?


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


What is RMS migrations?


tell me the disaster recovery plan


What is data modeling and Reterminal integrity?


How to restore performance issues and how to check?


What is the difference between NOROW and LOCKROW?


on line cluster can we make if yes tell me the procedure


how to overcome kernel isssues


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


How to convert a table data in XML format in sql server?


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


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


where the connection string store in the database