Tag: 2008R2 SP1

Changes from SQL 2008 R2 to SQL 2008 R2 SP1 Here is my comparison of changes for the SQL 2008 R2 SP1 update. New Column(s) sys.dm_exec_query_stats http://msdn.microsoft.com/en-us/library/ms189741.aspx sys.dm_os_sys_info http://msdn.microsoft.com/en-us/library/ms175048.aspx New Stored Procedure(s) This procedure raises the number of partitions from 1000 to 15000. sys.sp_db_increased_partitions http://technet.microsoft.com/en-us/library/hh204563.aspx New Views(s) sys.dm_os_windows_info http://technet.microsoft.com/en-us/library/hh204565.aspx sys.dm_server_registry http://technet.microsoft.com/en-us/library/hh204561.aspx sys.dm_server_services http://technet.microsoft.com/en-us/library/hh204542.aspx sys.dm_server_memory_dumps http://technet.microsoft.com/en-us/library/hh204543.aspx…