SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM, HCL, Wipro, NIIT,

38 63749

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

TCS,

2 3294

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.

1618




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 1523

what is advantages in sql 2005 over sql 2000?

4 4882

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

1501

Differnce between sel server 2000 and 2005

3 3630

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 3410




What is the difference Between Sql-server 2000 & 2005

Value Labs, Wipro,

3 7303

difference between sql server2000 and sql server2005

KPMG,

1 3455

Why Do you want to work in this company?

HCL,

4 3870

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

2 3625

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

1 2493

how to rename the table

3 4036

how many type of subquery?

2 4884


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

If we delete pack Spec what will be the status of pack Body ?

177


What are the dis_advantages of stored procedures, triggers, indexes?

969


Working with TLogs

683


how to use DTS package in 2000,2005,2008 in sql server

779


can any body tell me how to know the password of current user in sql server

919






Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

596


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

854


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

705


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1333


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

1253


Which is the best place or learning center for MS SQL?????In Bangladesh?????

879


role of sql sever 2005 in database rather than any other database

883


What is data modeling and Reterminal integrity?

668