Better Backups

Question

Better Backups

Viewing 14 posts - 31 through 43 (of 43 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Good question Steve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ken SSCoach Points: 17191 More actions · Answer 2

Good question. Made me look up BOL as I had never thought to use Resource Governor that way.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 3

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

January 23, 2012 at 11:01 am

#1437247

Tks Steve - good question

Julie Hall of Fame Points: 3292 More actions · Answer 4

I am glad I don't get a chance to look at the QOD until late in the day. That way everyone else has proofread the question and answer choices!

😛

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 5

I desagree with every one because Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

The question was 'on your SQL Server 2008 R2 databases.' which would mean by default the "standard" edition so the answer with "Resource Gvernor" cannot be a good answer 😛

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 6

KWymore (1/23/2012)
Good question. Made me look up BOL as I had never thought to use Resource Governor that way.

BWAA-HAAA!!! The only "Resource Governor" that I use is denial of ad hoc privs in production. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 7

Michael Valentine Jones

SSC Guru

Points: 64818

January 23, 2012 at 8:41 pm

#1437451

Didn't realize you could select two answers.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 8

tilew-948340 (1/23/2012)
I desagree with every one because Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.
The question was 'on your SQL Server 2008 R2 databases.' which would mean by default the "standard" edition so the answer with "Resource Gvernor" cannot be a good answer 😛

Default being the "standard" edition. Where Oh Where is that stated ?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 9

palotaiarpad

SSCertifiable

Points: 5617

January 24, 2012 at 2:32 am

#1437521

Thanks a lot! My points are back! 😎

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 10

Great question, thanks.

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

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 11

Good question. I knew the answer but checked the wrong box. Do I get 1/2 a point?

http://brittcluff.blogspot.com/

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 12

A informative question. Thx

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 13

bitbucket-25253 (1/23/2012)
tilew-948340 (1/23/2012)
I desagree with every one because Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.
The question was 'on your SQL Server 2008 R2 databases.' which would mean by default the "standard" edition so the answer with "Resource Gvernor" cannot be a good answer 😛
Default being the "standard" edition. Where Oh Where is that stated ?

Well... "Standard" means "standard" isn't it? 😀

tilew-948340 Hall of Fame Points: 3431 More actions · Answer 14

It would cost nothing to change the question to add the edition would not it?

Steve, could you please change the question for "on your SQL Server Enterprise 2008 R2 databases" (or something like that)

Thanks (and thanks for the question, still learning, so it was a good question)