SQL Server 2008 R2

  • rvasanth

    SSC Eights!

    Points: 873

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

  • sharath.chalamgari

    SSCertifiable

    Points: 5680

    Simple one, First one to answer ๐Ÿ™‚

  • pravin wagh

    SSC Veteran

    Points: 223

    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.

  • Hugo Kornelis

    SSC Guru

    Points: 64685

    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/

  • Carlo Romagnano

    SSC-Insane

    Points: 21965

    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.

  • amarshall-568002

    Right there with Babe

    Points: 785

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

  • Daniel Bowlin

    SSC-Dedicated

    Points: 34566

    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.

  • jcrawf02

    SSC-Insane

    Points: 24198

    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."

  • jeff.mason

    SSCrazy Eights

    Points: 9555

    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • mtillman-921105

    SSCertifiable

    Points: 7049

    Good question, thanks. ๐Ÿ™‚

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

  • daveb87

    Ten Centuries

    Points: 1025

    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.

  • Revenant

    SSC-Forever

    Points: 42467

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

  • UMG Developer

    SSChampion

    Points: 13482

    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.)

  • Geoff A

    SSChampion

    Points: 11417

    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 18 total)

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