This is a presentation I prepared for some of my colleagues at NSB Retail Systems before we became part of British Telecom. The aim of this was to provide cross training into SQL Server for Oracle professionals. The information was correct as of SQL Server version 2000, since then SQL Server has evolved to incorporate the following changes (to name but four), however the core concepts are still very much the same:-
- there have been numerous transact SQL enhancements
- The internals have been exposed somewhat via dynamic management views
- Query Analyzer, Enterprise Manager and OLAP Analysis manager have been consolidated into "Management studio".
- There is a new database tuning advisor
No comments:
Post a Comment