SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM, HCL, Wipro, NIIT,

38 62993

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

TCS,

2 3199

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.

1524




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 1464

what is advantages in sql 2005 over sql 2000?

4 4769

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

1450

Differnce between sel server 2000 and 2005

3 3549

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 3333




What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7182

difference between sql server2000 and sql server2005

KPMG,

1 3391

Why Do you want to work in this company?

HCL,

4 3763

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

2 3538

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

1 2416

how to rename the table

3 3943

how many type of subquery?

2 4790


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If the job running very slow what is the action you do

663


Delete duplicate rows without using rowid.

135


What is best institute to Learn DotNET And SQL in chennai?

912


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

605


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

817






Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

796


what are the Prerequisites for Replication?

8231


sql database suspect We have a sql database that is showing as suspect. How can we recover?

670


If a stored procedure is taking a table data type, how it looks?

4560


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

768


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

795


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

889


What is data modeling and Reterminal integrity?

618


how to take backup bcp out for a column in table in sql server?

804


how to do partition in sqlserver

1264