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 89631

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

TCS,

2 5442

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.

2929

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 3459

what is advantages in sql 2005 over sql 2000?

4 7977

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

2750

Differnce between sel server 2000 and 2005

3 6306

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 5139

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 10499

difference between sql server2000 and sql server2005

KPMG,

1 5240

Why Do you want to work in this company?

HCL,

4 6983

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

2 5841

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

1 4198

how to rename the table

3 7331

how many type of subquery?

2 7129

Un-Answered Questions { SQL Server }

What is the largest component inside a field?

1127

What do we have to check in database testing?

1019

Can you roll back the ddl statement in a trigger?

968

How do you handle datasets larger than 50 gb?

162

What is a domain constraint give an example?

1049

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1203

Difference between 2NF &3NF ?

1084

Explain how to integrate the ssrs reports in application?

1017

What are xml indexes?

952

what is a join? : Sql server database administration

1247

Write a sql query to display the current date?

1093

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

How many ways to create table-valued functions?

986

What is the difference between system objects and user objects?

1159

What the different topologies in which replication can be configured?

1087

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