22:18
Unknown
MSDE is a royalty free, redistributable and cut short version of the giant SQL SERVER database. It's primarily provided as a low cost option for developers who need database server which can easily be shipped and installed. It can serve as good alternative for Microsoft Access database as it over comes quiet a lot of problems which ACCESS has.
Below is a complete list which can give you a good idea of differences:-
=> Size of database: - MS ACCESS and MSDE have a limitation of 2GB while SQL SERVER has 1,048,516 TBI.
=> Performance degrades in MSDE 2000 when maximum number of concurrent operations goes above 8 or equal to 8. It does not mean that you can not have more than eight concurrent operations but the performance degrades. Eight connection performance degradation is implemented by using SQL SERVER 2000 work load governor (we will be looking in to more detail of how it works). As compared to SQL SERVER 2000 you can have 32,767 concurrent connections.
=> MSDE does not provide OLAP and Data ware housing capabilities.
=> MSDE does not have support facility for SQL mail.
=> MSDE 2000 does not have GUI administrative tool such as enterprise manager, Query analyzer or Profiler. But there are round about ways by which you can manage MSDE 2000:-
=> Old command line utility OSQL.EXE.
=> VS.NET IDE Server Explorer: - Inside VS.NET IDE you have a functionality which can give you a nice GUI administrative tool to manage IDE.
=> SQL SERVER WEB Data administrator installs a web based GUI which you can use to manage your database. For any details refer http://www.microsoft.com/ downloads/details.aspx?familyid=c039a798-c57a-419e-acbc-2a332cb7f959& displaylang=n
=> SQL-DMO objects can be used to build your custom UI.
=> There are lots of third party tools which provide administrative capability GUI, which is out of scope of the book as it's only meant for interview questions.
=> MSDE does not support Full text search.
Below is a complete list which can give you a good idea of differences:-
=> Size of database: - MS ACCESS and MSDE have a limitation of 2GB while SQL SERVER has 1,048,516 TBI.
=> Performance degrades in MSDE 2000 when maximum number of concurrent operations goes above 8 or equal to 8. It does not mean that you can not have more than eight concurrent operations but the performance degrades. Eight connection performance degradation is implemented by using SQL SERVER 2000 work load governor (we will be looking in to more detail of how it works). As compared to SQL SERVER 2000 you can have 32,767 concurrent connections.
=> MSDE does not provide OLAP and Data ware housing capabilities.
=> MSDE does not have support facility for SQL mail.
=> MSDE 2000 does not have GUI administrative tool such as enterprise manager, Query analyzer or Profiler. But there are round about ways by which you can manage MSDE 2000:-
=> Old command line utility OSQL.EXE.
=> VS.NET IDE Server Explorer: - Inside VS.NET IDE you have a functionality which can give you a nice GUI administrative tool to manage IDE.
=> SQL SERVER WEB Data administrator installs a web based GUI which you can use to manage your database. For any details refer http://www.microsoft.com/ downloads/details.aspx?familyid=c039a798-c57a-419e-acbc-2a332cb7f959& displaylang=n
=> SQL-DMO objects can be used to build your custom UI.
=> There are lots of third party tools which provide administrative capability GUI, which is out of scope of the book as it's only meant for interview questions.
=> MSDE does not support Full text search.
0 comments:
Post a Comment