Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server 2008 R2 Expand / Collapse
Author
Message
Posted Thursday, October 21, 2010 9:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, January 10, 2013 6:16 AM
Points: 299, Visits: 114
Comments posted to this topic are about the item SQL Server 2008 R2
Post #1008943
Posted Thursday, October 21, 2010 11:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:29 AM
Points: 1,179, Visits: 786
Simple one, First one to answer
Post #1008964
Posted Friday, October 22, 2010 12:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:45 PM
Points: 132, Visits: 212
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.
Post #1008978
Posted Friday, October 22, 2010 2:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 5,977, Visits: 8,237
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
Post #1008999
Posted Friday, October 22, 2010 2:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 2,502, Visits: 2,384
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.
Post #1009014
Posted Friday, October 22, 2010 6:09 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, February 2, 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.
Post #1009115
Posted Friday, October 22, 2010 6:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:18 PM
Points: 2,818, Visits: 2,561
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.
Post #1009142
Posted Friday, October 22, 2010 7:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 2,670, Visits: 19,241
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."
Post #1009162
Posted Friday, October 22, 2010 7:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, August 18, 2014 7:25 AM
Points: 989, Visits: 1,823
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.
Post #1009175
Posted Friday, October 22, 2010 7:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 13,622, Visits: 10,513
Nice and easy. Thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1009186
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse