Follow Our FB Page << CircleMedia.in >> 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

TCS,

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.

2093

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

1819

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

KPMG,

1 3940

Why Do you want to work in this company?

HCL,

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?

185


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

188


what is isolation level at dead lock?

1372


What is indexing a document?

180


How to test subquery results with the exists operator?

223






Explain filestream storage of sql server 2008?

201


What is a cursor, index in sql?

211


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

199


What are logical/boolean operations in ms sql server?

216


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

195


Which joins are sql server default?

164


How to convert character strings into numeric values?

216


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

181


Explain about builtinadministrator?

194


What is an identity column in insert statements?

213