1.Difference between Database Mail and SQL Mail
-
S.No Database Mail SQL Mail 1 Based on SMTP (Simple Mail Transfer Protocol).Based on MAPI (Messaging Application Programming Interface).2 Introduced in Sql Server 2005.Used prior versions of Sql Server 2005.3 No need to install Outlook.Require Outlook to be installed.4 More secure than Sql mail.Less secure than Database mail.
-
S.No Azure Table storage SQL Azure 1 It is built on top of the Azure Storage platform.It is an SQL Server that has been configured to be hosted on top
of the Windows Azure in a high availability mode.2 It comprises flexible or schema-less entities. No referential integrity between the tables, and no custom indexes.It comprises standard SQL Tables with indexes and referential integrity.3 It can scale massive amounts of data due to the partition key.It may not scale as far as Azure Table storage.4 Can be thought as single spreadsheet.Look familiar to any .Net developer who has used Sql server 2008 prior.
-
S.No DBMS RDBMS 1 Stands for DataBase Management SystemStands for Relational DataBase Management System2 In dbms no relationship conceptIt is used to establish the relationship concept between two database objects, i.e, tables3 It supports Single User onlyIt supports multiple users4 It treats Data as Files internallyIt treats data as Tables internally5 It supports 3 rules of E.F.CODD out off 12 rulesIt supports minimum 6 rules of E.F.CODD6 It requires low Software and Hardware Requirements.It requires High software and hardware requirements.7 DBMS is used for simpler business applicationsRDBMS is used for more complex applications.8 DBMS does not impose any constraints or security with regard to data manipulationRDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY9 In DBMS Normalization process will not be presentIn RDBMS, normalization process will be present to check the database table consistency10 There is no enforcement to use foreign key concept compulsorily in DBMSAlthough the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules11 FoxPro, IMS are ExamplesSQL Server, Oracle are examples
4.Difference
between SQL Server 2000 and SQL Server 2005
-
S.No SQL Server 2000 SQL Server 2005 1 Query Analyser and Enterprise manager are separate.Both are combined as SSMS(Sql Server management Studio).2 No XML datatype is used..XML datatype is introduced.3 We can create maximum of 65,535 databases.We can create 2(pow(20))-1 databases.4 Exception Handling mechanism is not availableException Handling mechanism is available5 There is no Varchar(Max) data type is not availableVarchar(Max) data type is introduced.6 DDL Triggers is not availableDDL Triggers is introduced7 DataBase Mirroring facility is not availableDataBase Mirroring facility is introduced8 RowNumber function for paging is not availableRowNumber function for paging is introduced9 Table fragmentation facility is not availableTable fragmentation facility is introduced10 Full Text Search facility is not availableFull Text Search facility is introduced11 Bulk Copy Update facility is not availableBulk Copy Update facility is introduced12 Data Encryption concept is not introduced13 Cannot compress the tables and indexes.Can Compress tables and indexes.(Introduced in 2005 SP2)14 No varchar(max) or varbinary(max) is available.Varchar(max) and varbinary(max) is used.15 Data Transformation Services(DTS) is used as ETL toolSQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool
No comments:
Post a Comment