Search
Subscribe
Categories
- Backup and Restore
- Capacity Planning
- Compression
- Configure
- Contact me
- CPU
- Data Architecture
- Data Import and Export
- Database Mirroring
- DBA
- DBA Scripts
- DBCC
- Deadlocks
- Default Trace
- Development
- Disaster Recovery
- Disk Storage
- DMV
- Documentation
- Event Log
- Execution Plan
- Function
- High Availability
- Indexes
- Install & Setup
- Interviews
- IO Subsystem
- Isolation levels
- Jobs
- Latches
- Links
- Locking
- Memory
- Monitor Performance
- MS DTC
- MSDB
- Network
- Object Management
- Pagination
- Partitioning
- Performance
- Powershell
- Security Management
- SQL Agent
- SQL Azure
- SQL Blocking
- SQL Cachestore
- SQL DAC
- SQL Default Trace
- SQL DTS
- SQL Error Logs
- SQL Execution Plan
- SQL Optimizer
- SQL problems
- SQL Query Tuning
- SQL Server Error Tips
- SQL Server Management Studio
- SQL Server Profiler
- SQL Server Tuning
- SQL Trigger
- SQL View
- SQLServer-DBA News
- SSIS
- Statistics
- Stored Procedure
- T-SQL
- TempDB
- Tools
- TPC-H
- Transaction Logs
- View
- Virtualization
- Wait Stats
SQLServer-DBA.com Links
Recent Posts
- Forgotten sa password
- Sql server installation is either corrupt or has been tampered with error getting instance id from name
- Find Weak passwords in SQL Server
- Event ID 55 : The file system structure on the disk is corrupt and unusable on volume
- Career in DBA
- Error 3254 – The volume on device BACKUP_PATH is empty
- SQL auto close - Keep it turned off
- Windows Pagefile size for dedicated SQL Servers
- SQL Database Corruption
- max server memory and sql server memory – why is total memory greater than max memory?
06 March,2012 by Jack Vamvas
1) SQL Server 2008 R2 Reporting Services doesn’t support Windows 2003 (or R2) Itanium based servers
2) SQL-DMO support is stopped in SQL Server 2008 Express
3) Cannot enable Web Assistant with sp_configure. MS recommend using Reporting Services
4) Surface Area Configuration Tool is discontinued in SQL Server 2008.
5) Unattended Installations. SQL Server 2005 Scripts using /Q or /QS also need /IAcceptSQLServerLicenseTerms
6) SMO for 2005 is modified slightly for 2008. Applications using 2005 SMO dlls should refer to 2008 supplied dlls
7) Consider the deprecated list of features in 2008. Lists exists for features not appearing in the next version and features not appearing Review code and consider changing. Some examples are: DBCC DBREINDEX replaced by REBUILD option of ALTER INDEX , DBCC SHOWCONTIG replaced by sys.dm_db_index_physical_stats. Check the Microsoft site for the full list
8) SQL Server 2008 R2 Enterprise Edition uses 8 CPU as maximum . Datacenter is required if more than 8 CPU is required
Download a detailed document from Microsoft
See Also
SQL server 2008 R2 – Silent installation for the SSMS and client tools
SQL Index Fragmentation and sys.dm_db_index_physical_stats
Author: Jack Vamvas (http://www.sqlserver-dba.com)
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |