SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM, HCL, Wipro, NIIT,

38 63349

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

TCS,

2 3238

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.

1573




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 1486

what is advantages in sql 2005 over sql 2000?

4 4819

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

1472

Differnce between sel server 2000 and 2005

3 3576

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 3362




What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7225

difference between sql server2000 and sql server2005

KPMG,

1 3417

Why Do you want to work in this company?

HCL,

4 3812

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

2 3568

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

1 2446

how to rename the table

3 3979

how many type of subquery?

2 4819


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is data modeling and Reterminal integrity?

632


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

813


how many no of arguments can be passed in procedures and functions

3451


1 01 101 01010

711


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

936






how to take backup bcp out for a column in table in sql server?

820


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

641


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

1369


whats the maximum size of view state??

914


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?

755


If a stored procedure is taking a table data type, how it looks?

4587


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1118


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

1472


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

648


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

4627