Difference between SQL-Server 2005 and SQL-Server 2008
1. In sql server 2005 we can not encrypt the database, while in sql server 2008 we can encrypt the entire database.
2. No table datatype is in sql-server 2005.
3. Central management system is introduced in 2008.
4. Policy based management(PBM) server is Introduced in sql 2008.
5. In sql server 2005,There is no option to compress backup files, but in sql server 2008.
6. Merge statement is introduced in sqlsever 2008
7. Value assignment at the time of vaiable declaration in SQL 2008
8. Ability to pass table variables into the stored procedures in SQL 2008
Difference between SQL-Server 2008 and SQL-Server 2012
1. The Maximum number concurrent connections to SQL Server 2008 is 32767. SQL server 2012 has unlimited concurrent connections.
2. The SQL Server 2008 uses 27 bit precision for spatial calculations. The SQL Server 2012 uses 48 bit precision for spatial calculations
3. TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008.
4. ORDER BY Clause now have OFFSET / FETCH options to use paging to show required rows per page in applications and allow the user to scroll through each page of results rather than download the entire setIn the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.
SELECT BusinessEntityID, FirstName, LastName FROM Person.Perso ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;
5. Sequence is included in SQL Server 2012.Sequence is a user defined object that generates a sequence of a number. Here is an example using Sequence.
/****** Create Sequence Object ******/
CREATE SEQUENCE MySequence
START WITH 1
INCREMENT BY 1;
/****** Create Temp Table ******/
DECLARE @Person TABLE
(
ID int NOT NULL PRIMARY KEY,
FullName nvarchar(100) NOT NULL
);
/****** Insert Some Data ******/
INSERT @Person (ID, FullName) VALUES (NEXT VALUE FOR MySequence, 'Umar Ali'),
(NEXT VALUE FOR MySequence, 'John Peter'),
(NEXT VALUE FOR MySequence, 'Mohamed Iqbal');
/****** Show the Data ******/
SELECT * FROM @Person;
The results would look like this:
ID FullName
1 Umar Ali
2 John Peter
3 Mohamed Iqbal
6. The Full Text Search in SQL Server 2012 has been enhanced by allowing us to search and index data stored inextended properties or metadata. Consider a PDF document that has "properties" filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it's possible now.
1. In sql server 2005 we can not encrypt the database, while in sql server 2008 we can encrypt the entire database.
2. No table datatype is in sql-server 2005.
3. Central management system is introduced in 2008.
4. Policy based management(PBM) server is Introduced in sql 2008.
5. In sql server 2005,There is no option to compress backup files, but in sql server 2008.
6. Merge statement is introduced in sqlsever 2008
7. Value assignment at the time of vaiable declaration in SQL 2008
8. Ability to pass table variables into the stored procedures in SQL 2008
Difference between SQL-Server 2008 and SQL-Server 2012
1. The Maximum number concurrent connections to SQL Server 2008 is 32767. SQL server 2012 has unlimited concurrent connections.
2. The SQL Server 2008 uses 27 bit precision for spatial calculations. The SQL Server 2012 uses 48 bit precision for spatial calculations
3. TRY_CONVERT() and FORMAT() functions are not available in SQL Server 2008.
4. ORDER BY Clause now have OFFSET / FETCH options to use paging to show required rows per page in applications and allow the user to scroll through each page of results rather than download the entire setIn the sample query below, SQL Server would return 10 records beginning with record 11. The OFFSET command provides a starting point for the SELECT statement in terms of paging, and the FETCH command provides how many records to return at a time.
SELECT BusinessEntityID, FirstName, LastName FROM Person.Perso ORDER BY BusinessEntityID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;
5. Sequence is included in SQL Server 2012.Sequence is a user defined object that generates a sequence of a number. Here is an example using Sequence.
/****** Create Sequence Object ******/
CREATE SEQUENCE MySequence
START WITH 1
INCREMENT BY 1;
/****** Create Temp Table ******/
DECLARE @Person TABLE
(
ID int NOT NULL PRIMARY KEY,
FullName nvarchar(100) NOT NULL
);
/****** Insert Some Data ******/
INSERT @Person (ID, FullName) VALUES (NEXT VALUE FOR MySequence, 'Umar Ali'),
(NEXT VALUE FOR MySequence, 'John Peter'),
(NEXT VALUE FOR MySequence, 'Mohamed Iqbal');
/****** Show the Data ******/
SELECT * FROM @Person;
The results would look like this:
ID FullName
1 Umar Ali
2 John Peter
3 Mohamed Iqbal
6. The Full Text Search in SQL Server 2012 has been enhanced by allowing us to search and index data stored inextended properties or metadata. Consider a PDF document that has "properties" filled in like Name, Type, Folder path, Size, Date Created, etc. In the newest release of SQL Server, this data could be indexes and searched along with the data in the document itself. The data does have to be exposed to work, but it's possible now.
Good Explanation
ReplyDeleteThanks.. Sandeep
Delete