SQL Server 2008 R2

  • Comments posted to this topic are about the item SQL Server 2008 R2

  • Simple one, First one to answer ๐Ÿ™‚

  • some other features are ;

    1. Self-service BI with Project Gemini

    2. Support for 256 logical processors

    3. SQL Server Express has been increased from 4 GB to 10 GB.

  • I got it wrong. I blame my total lack of interest in the R2 release.

    But a quick question - if Multi-Server Administration was a new feature in SQL Server 2008 R2, then why is there an article about Multuiserver Administration in Books Online for SQL Server 2000? See this link.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Hugo Kornelis (10/22/2010)


    I got it wrong. I blame my total lack of interest in the R2 release.

    But a quick question - if Multi-Server Administration was a new feature in SQL Server 2008 R2, then why is there an article about Multuiserver Administration in Books Online for SQL Server 2000? See this link.

    I got it right, but I agree with you about "Multuiserver Administration", maybe it's new from Visual Studio????

    I found this http://www.digitchannelconnect.com/content/sql-server-2008-r2#

    (Page 2)

    Manage and monitor

    Among the new features included in SQL Server 2008 R2โ€™s Management Studio application is the SQL Server Utility, which enables administrators to manage and monitor multiple database applications and server instances from a central interface called a Utility Control Point (UCP). I used the SQL Server Utility to group a pair of Server 2008 R2 instances together and track utilization and policy information for the instances from the Management Studioโ€™s Utility Explorer interface.

  • I don't agree with the answer. Multiserver administration is available with sql 2008, unless I'm missing something.

  • I knew 2 of them were new, so with radio buttons the only choice was all of the above. It would have been tougher with check boxes. Thanks.

  • Yeah, that BOL article is misleading, I would argue that PowerPivot is completely unrelated to SQL Server 2008 R2, it depends on Excel 2010 and is a separate web download into that tool, you can use that without using SQL Server at all. Was pretty sure the Multiserver admin was already there too, but that's not my strong suit.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • Hugo Kornelis (10/22/2010)


    I got it wrong. I blame my total lack of interest in the R2 release.

    But a quick question - if Multi-Server Administration was a new feature in SQL Server 2008 R2, then why is there an article about Multuiserver Administration in Books Online for SQL Server 2000? See this link.

    Yeah, I see that point. I got it right because we are planning on using the new feature -- he was talking about the control points, the central server management features new to R2. The term chosen was confusing.

  • Nice and easy. Thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question, thanks. ๐Ÿ™‚

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • I agree, Multi Server administration was available pre-2008 r2. However, what is new is the SQL Server Utility for managing performance data and management policies.

    http://msdn.microsoft.com/en-us/library/bb500435.aspx

    So technically the answer of "Multi Server Administration" is not correct.

  • Interesting that it entirely misses support for the Cloud, which was the main reason for the refresh...

  • Thanks for the question.

    Though I think it would have been better as a multi-select question. (Of course that would have caused more problems with the multi-server administration option.)

  • Multi-server admin was added in 2008 and is technically NOT a SQL Server feature but an SSMS feature.

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply