SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM, HCL, Wipro, NIIT,

38 65031

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

TCS,

2 3410

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.

1748




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 1610

what is advantages in sql 2005 over sql 2000?

4 5044

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

1559

Differnce between sel server 2000 and 2005

3 3737

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 3497




What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7465

difference between sql server2000 and sql server2005

KPMG,

1 3551

Why Do you want to work in this company?

HCL,

4 4013

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

2 3722

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

1 2600

how to rename the table

3 4184

how many type of subquery?

2 4980


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How much memory that we are using in Logshipping Concept?

775


SQL Server Architecture ?

1206


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

947


Why do you want to join software field as you have done your BE in Electronics?

1093


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

748






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

911


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

945


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1119


How we create SQL Server 2005 Reporting Services ? Give me Sample

983


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

999


What is Lock table in SQL?

354


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?

861


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

380


plss anybody specify tha constrian management system in dbms

885


What is the difference between NOROW and LOCKROW?

1393