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.