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 89565

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

TCS,

2 5438

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.

2925

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 3450

what is advantages in sql 2005 over sql 2000?

4 7961

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

2742

Differnce between sel server 2000 and 2005

3 6294

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 5130

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 10480

difference between sql server2000 and sql server2005

KPMG,

1 5240

Why Do you want to work in this company?

HCL,

4 6973

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

2 5837

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

1 4187

how to rename the table

3 7325

how many type of subquery?

2 7116

Un-Answered Questions { SQL Server }

What is key attribute?

929

What is 5nf in normalization form?

989

How to use values from other tables in update statements in ms sql server?

1107

What are diverse clauses that form a part of sql?

1064

What is the largest component inside a field?

1117

What are sql azure firewall rules?

106

What are out-of-range errors with date and time literals?

1027

What is difference between views and tables?

1006

How to create new tables with "create table" statements in ms sql server?

1061

How to maintain a fill factor in existing indexes?

998

Define cross join in sql server joins?

1019

What are the extra roles available in msdb? : sql server security

1125

What are logical/boolean operations in ms sql server?

1033

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

898

what is blocking? : Sql server database administration

1033

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