SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM, HCL, Wipro, NIIT,

38 64394

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

TCS,

2 3352

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.

1673




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 1563

what is advantages in sql 2005 over sql 2000?

4 4968

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

1527

Differnce between sel server 2000 and 2005

3 3680

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 3447




What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7390

difference between sql server2000 and sql server2005

KPMG,

1 3496

Why Do you want to work in this company?

HCL,

4 3944

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

2 3680

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

1 2539

how to rename the table

3 4119

how many type of subquery?

2 4930


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

907


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

899


What is the difference between NOROW and LOCKROW?

1340


1 01 101 01010

788


ow to bring suspect mode datbase online from scratch

724






whats new about truncate in sql server 2008?

1344


Tell about MOM Tool(Microsoft Operator Manager)?

719


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.

1620


Delete duplicate rows without using rowid.

229


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1540


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

906


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.

733


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

818


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4825


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

1439