7.27.2012

SQL Server Difference FAQs- 5


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.

2.Difference between Azure Table storage and SQL Azure
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.

3.Difference between DBMS and RDBMS
S.No DBMS RDBMS
1
Stands for DataBase Management System
Stands for Relational DataBase Management System
2
In dbms no relationship concept
It is used to establish the relationship concept between two database objects, i.e, tables
3
It supports Single User only
It supports multiple users
4
It treats Data as Files internally
It treats data as Tables internally
5
It supports 3 rules of E.F.CODD out off 12 rules
It supports minimum 6 rules of E.F.CODD
6
It requires low Software and Hardware Requirements.
It requires High software and hardware requirements.
7
DBMS is used for simpler business applications
RDBMS is used for more complex applications.
8
DBMS does not impose any constraints or security with regard to data manipulation
RDBMS defines the integrity constraint for the purpose of holding ACID PROPERTY
9
In DBMS Normalization process will not be present
In RDBMS, normalization process will be present to check the database table consistency
10
There is no enforcement to use foreign key concept compulsorily in DBMS
Although the foreign key concept is supported by both DBMS and RDBMS but its only RDBMS that enforces the rules
11
FoxPro, IMS are Examples
SQL 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 available
Exception Handling mechanism is available
5
There is no Varchar(Max) data type is not available
Varchar(Max) data type is introduced.
6
DDL Triggers is not available
DDL Triggers is introduced

7
DataBase Mirroring facility is not available
DataBase Mirroring facility is introduced
8
RowNumber function for paging is not available
RowNumber function for paging is introduced
9
Table fragmentation facility is not available
Table fragmentation facility is introduced

10
Full Text Search facility is not available
Full Text Search facility is introduced

11
Bulk Copy Update facility is not available
Bulk Copy Update facility is introduced
12
Data Encryption concept is not introduced
.Cannot encrypt the entire database

13
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 tool
SQL Server Integration Services(SSIS) is started using from this SQL Server version and which is used as ETL tool

No comments:

Post a Comment