Most popular question asked by database developers is why we migrated to SQL Server 2008? What is the new feature in 2008 which was not in 2005?
Here is brief summary of the differences and I will try to explain why SQL Server 2008 is rocking.
1- Plug is model for SSMS:- SSMS 2005 also had a plug in model but this was not published.
2- Inline variable assignment:-
Instead of:
DECLARE @myVar int
SET @myVar = 5
you can do it in one line:
DECLARE @myVar int = 5
3- Filtered index:- it allows you to create an index while specifying what rows are not to be in the index. For example, index all rows where Status != null.
4- Intellisense:- in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with Intellisense use of 3rd party add-ins like SQL Prompt ($195). But these tools are a horrible hack at best.
No comments:
Post a Comment