Babar
8624
0
6/15/2012 (IST)
2
Introduction
The table shows the differences between sqlserver different versions. This can be helpful in interview questions.
| Sql server 2000 | Sql server 2005 | Sql server 2008 |
|---|---|---|
| Query analyser and enterprise manager are seperate | Both are combined into SSMS(sql server management studio) | Both are combined as SSMS |
| No XML datatype used | XML datatype is introduced | XML datatype is used |
| We can create maximum of 65,535 databases only | We can create maximum of (2^20)-1 databases | We can create maximum of (2^20)-1 databases |
| Nil | Exception handling | Exception handling |
| Nil | Varchar(max) datatype | Varchar(max) datatype |
| Nil | DDL triggers | DDL triggers |
| Nil | Database mirroring(sql DBA) | Database mirroring |
| Nil | Row number function for paging | Row number function for paging |
| Nil | Table fragmentation | Table fragmentation |
| Nil | Full text search | Full text search |
| Nil | Bulk copy insert | Bulk copy update |
| Nil | Can't encrypt | Can encrypt the entire database introduced in 2008 |
| Can't compress the tables and indexes | Can compress tables and indexes(introduced in 2005 SP2) | Can compress tables and indexes |
| Datetime datatype used for both date and time | Datetime datatype used for both date and time | Date & time are seperately used for date & time datatype, geospatial and timestamp with internal timezone is used |
| No varchar(max) or varbinary(max) is available | varchar(max) and varbinary(max) is used | varchar(max) and varbinary(max) is used |
| No table datatype is introduced | Table datatype is introduced | Table datatype is introduced |
| No SSIS is included | SSIS is started using | SSIS available in this version |
| CMS(centralized management server) is not available | CMS is not available | CMS is introduced |
| PBM(policy based management) is not available | PBM is not available | PBM server is introduced |
Comments/Suggestions are invited. Happy coding......!
Comments Post a Comment
pavan 1/21/2013 (IST) / Reply
Very good information
deepak 4/16/2013 (IST) / Reply
The maximum no of database for a single is wrong.3200Aprox.