Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL Server Interview Questions
Questions Answers Views Company eMail

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

HCL, IBM, NIIT, Wipro,

38 71513

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


2 3891

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 2032

what is advantages in sql 2005 over sql 2000?

4 5710

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


Differnce between sel server 2000 and 2005

3 4316

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 3885

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 8138

difference between sql server2000 and sql server2005


1 3940

Why Do you want to work in this company?


4 4721

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

2 4197

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

1 3051

how to rename the table

3 5089

how many type of subquery?

2 5466

Un-Answered Questions { SQL Server }

Is mysql better than sql server?


What do you understand by user-defined function in the sql server?


what is isolation level at dead lock?


What is indexing a document?


How to test subquery results with the exists operator?


Explain filestream storage of sql server 2008?


What is a cursor, index in sql?


What specific conditions database should meet, before you can bulk copy data into it using bcp?


What are logical/boolean operations in ms sql server?


Can you tell me some of the common replication dmv's and their use? : sql server replication


Which joins are sql server default?


How to convert character strings into numeric values?


what is the information that can be stored inside a bit column? : Sql server database administration


Explain about builtinadministrator?


What is an identity column in insert statements?