ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
what is advantages in sql 2005 over sql 2000?
 Question Submitted By :: Ramkumar
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is advantages in sql 2005 over sql 2000?
Answer
# 1		 
Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql 
server 2000. SSRS with adhoc reporting. Some sys command 
are changed like sys.objects, sys.columns.
 
Is This Answer Correct ?    6 Yes 0 No
Ashis
 
  Re: what is advantages in sql 2005 over sql 2000?
Answer
# 2		 
sql server 2005 replaces query analyser and enterprise 
manager with management studio
 
Is This Answer Correct ?    1 Yes 1 No
Gowthami Radhakrishnan
 
 
 
  Re: what is advantages in sql 2005 over sql 2000?
Answer
# 3		 
Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or 
Drop table or Alter table).Created in either Database or 
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).
 
Is This Answer Correct ?    2 Yes 1 No
Subbu
 
  Re: what is advantages in sql 2005 over sql 2000?
Answer
# 4		 
Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH
 
Is This Answer Correct ?    1 Yes 1 No
Adhi
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
what is meant by sql injection with example and one more question how to catch the errors in sqlserver  1
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all) McAfee5
What are the steps you will take, if you are tasked with securing an SQL Server? HCL1
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
wht's the differece between sqlserver05 and sqlserver2000  3
How to delete an attribute from the emp table  3
Hi..here i would like to know the Backup and Restore models? HCL2
what are the problems in logshipping?  2
how to rename the table  3
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... TVS2
what is the output for this query select * from employee where 1=1;  4
What is RAID and what are different types of RAID configurations? Wipro5
what is diffence between replicaion and logshipping?  1
What is the difference between a Local temporary table and a Global temporary table? How is each one used?  1
What are Magic Table? Evalueserve16
what is maximum size of temp db? iSoft4
What is referential integrity? What are the advantages of it? Digital-Domain3
Explain some DBCC commands?  4
About DTS usage ? Cognizent2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com