1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

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

HCL, IBM, NIIT, Wipro,

38 79776

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

TCS,

2 4544

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.

2468

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 2784

what is advantages in sql 2005 over sql 2000?

 4 6781

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

 2174

Differnce between sel server 2000 and 2005

 3 5189

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 4381

What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 9242

difference between sql server2000 and sql server2005

KPMG,

1 4544

Why Do you want to work in this company?

HCL,

4 5779

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

 2 4905

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

 1 3611

how to rename the table

 3 6052

how many type of subquery?

 2 6191

Un-Answered Questions { SQL Server }

How to make a column nullable?

597

What is equi join with example?

551

What is a data source or ds? : sql server analysis services, ssas

562

What is user-defined inline table-valued function?

514

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1976




How to download and install sql server 2005 books online?

539

List out different types of normalizations in sql server and explain each of them?

554

What is the importance of a recovery model?

605

when you create a database how is it stored? : Sql server database administration

491

What is the difference between a clustered index and a non-clustered index?

531

What are the different types of indexes?

611

Why transaction is important?

563

Explain logical operators in sql server?

564

Please illustrate physical database architecture? : SQL Server Architecture

527

What is the use of sql profiler in sql server 2012?

511

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