DBCC Timewarp

Question

Post reply

DBCC Timewarp

Viewing 15 posts - 136 through 150 (of 158 total)

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

Paul White SSC Guru Points: 150467 More actions · Answer 1

Tom@Intel (4/1/2010)
technophobic proletariat

Yikes! :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

m--S3qU3L Hall of Fame Points: 3706 More actions · Answer 2

Used my friend's system. It contains Enterprise, so made a DAC to my Xpress (with my secret DBCC), then tried the DBCC TIMEWARP.

It turned out, SSC is not equiped with DBCC TIMEWARP. Steve - can we upgrade SSC now?

John

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

bigM (4/1/2010)
Used my friend's system. It contains Enterprise, so made a DAC to my Xpress (with my secret DBCC), then tried the DBCC TIMEWARP.
It turned out, SSC is not equiped with DBCC TIMEWARP. Steve - can we upgrade SSC now?

SSC is equipped with DBCC TimeWarp. I guess you don't have sufficient rights to use it. 😛

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Tom_Sacramento SSCertifiable Points: 6296 More actions · Answer 4

Steve, this sounds like a great idea! There is a languish/anticipatory switch. Ofcourse if it's not in the budget, then maybe we could get the just the last half part of the TimeWarp... oh wait, I see it. Home sweet home:-)

Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/

Paul White SSC Guru Points: 150467 More actions · Answer 5

Alvin Ramard (4/1/2010)
SSC is equipped with DBCC TimeWarp.

It will have been, by this time yesterday.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 6

Thanks for this thread, and the question. Went over well today, I think

m--S3qU3L Hall of Fame Points: 3706 More actions · Answer 7

I have been granted the rights.

But I'm stuck in an INFINITE LOOP now.

After getting the rights, I went to past using TIMEWARP (to try the TIMEWARP in the past as I intended), but in the past I have no rights (Just now only I got the rights).

So, again I went to the @past2 from @past1.. Its still continuing the process...@past 1234 and counting

Any help will be appreciated.

:w00t:

Tanx

bigM

John

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 8

Steve Jones - Editor (4/1/2010)
Thanks for this thread, and the question. Went over well today, I think

Steve, you forgot the 2nd part of the question for QoD: "List the parameters with their default values." 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

bigM (4/1/2010)
Can't believe this thread gave me a feeling of loosing 7 points for QoD (humour) this morning.
Yes. I lost the QoD about DBCC TIMEWARP. I couldnt find this thread in time.
I wish if theres something to go back and put 137 there in the answer.
Mad being a fool in April 1 2010.
Cheers DBAs

that is why we created dbcc timewarp - no you can go back and get the answer correct:-D

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

bigM (4/1/2010)
Used my friend's system. It contains Enterprise, so made a DAC to my Xpress (with my secret DBCC), then tried the DBCC TIMEWARP.
It turned out, SSC is not equiped with DBCC TIMEWARP. Steve - can we upgrade SSC now?

That should be fun

SSC has already experienced the timewarp once - this thread disappeared for half a day.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Steve Jones - Editor (4/1/2010)
Thanks for this thread, and the question. Went over well today, I think

I agree that the question went over quite well.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Alvin Ramard (4/1/2010)
Steve Jones - Editor (4/1/2010)
Thanks for this thread, and the question. Went over well today, I think
Steve, you forgot the 2nd part of the question for QoD: "List the parameters with their default values." 😀

Only on an open book exam. Oh wait - QOD is open book.

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

mojo-168709 SSCommitted Points: 1825 More actions · Answer 13

I'm a bit confused with a wrong answer, hence 7 points. If the question is categorized as humorous, how could it be a wrong answer, then? A wrong humor?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

mojo-168709 (4/1/2010)
I'm a bit confused with a wrong answer, hence 7 points. If the question is categorized as humorous, how could it be a wrong answer, then? A wrong humor?

Even with humor there is still a right way and a wrong way.

The humor is in the fake command. Thus based on the documentation of that fake command that we have provided, the question has to use the values that we provided.

Did you at least get a laugh out of this thread and the QOD?

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

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 15

Ever seen a joke bomb? It happens all the time to comics, so there can be a wrong attempt.

Actually it's more that our engine allows only "1 right answer" or "select all" and you have to select all. We never built in an "either-or"scenario, which I'd like.