SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

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

HCL, IBM, NIIT, Wipro,

38 90959

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

TCS,

2 5553

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.

2992

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 3559

what is advantages in sql 2005 over sql 2000?

4 8116

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

2830

Differnce between sel server 2000 and 2005

3 6473

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 5238

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 10634

difference between sql server2000 and sql server2005

KPMG,

1 5320

Why Do you want to work in this company?

HCL,

4 7135

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

2 5980

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

1 4284

how to rename the table

3 7469

how many type of subquery?

2 7252

Un-Answered Questions { SQL Server }

Can primary key be null?

986

What is update_statistics command?

1121

What is the maximum number of index per table?

1124

What is a db view?

951

How to connect ms access to sql servers through odbc?

1074

What are the default system databases in sql server 2000?

1085

Define left outer join?

1031

What new data source types were added in ssrs 2014?

169

What is xdr?

1046

What is the report builder?

143

What is log in sql server?

1208

Do you think BCNF is better than 2NF & 3NF? Why?

1343

what is dbcc? : Sql server database administration

1088

Is foreign key unique?

1051

What are the difference between primary key and unique key? : sql server database administration

994

For More Un-Answered { SQL Server } Questions Click Here