|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Thursday, January 10, 2013 6:16 AM
Points: 295,
Visits: 114
|
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038,
Visits: 679
|
|
Simple one, First one to answer
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Monday, November 26, 2012 4:40 AM
Points: 129,
Visits: 123
|
|
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.
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 5,235,
Visits: 7,036
|
|
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 MVP Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|
|
|
|
|
SSCommitted
      
Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 1,969,
Visits: 1,820
|
|
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.
|
|
|
|
|
Say Hey Kid
      
Group: General Forum Members
Last Login: Wednesday, February 02, 2011 4:11 AM
Points: 671,
Visits: 356
|
|
| I don't agree with the answer. Multiserver administration is available with sql 2008, unless I'm missing something.
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 2,672,
Visits: 2,417
|
|
| 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.
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Yesterday @ 12:09 PM
Points: 2,550,
Visits: 18,882
|
|
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 How to post performance problems Tally Table:What it is and how it replaces a loop
"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."
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Monday, May 06, 2013 6:51 AM
Points: 989,
Visits: 1,790
|
|
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.
|
|
|
|
|
SSCrazy Eights
        
Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370,
Visits: 6,467
|
|
|
|
|