DBCC Timewarp

Question

Post reply

DBCC Timewarp

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
March 31, 2010 at 8:47 pm

#75887

Comments posted to this topic are about the item DBCC Timewarp

Viewing 15 posts - 1 through 15 (of 53 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

Man, that was a lot of points for this question!

Happy April Fools!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

The holidays are a good time to boost your score. We usually do something fun and simple.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Let's do the timewarp together!!!

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 4

Awesome question!!!!!

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 5

I'm a bit disappointed... no mention of the hampster poo enhancement. 😛

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Jeff Moden (3/31/2010)
I'm a bit disappointed... no mention of the hampster poo enhancement. 😛

Or the optional parameters :hehe:

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

SanjayAttray SSChampion Points: 13157 More actions · Answer 7

Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D

Even tried to google it and found nothing much. Though on a fluke got the answer right.

SQL DBA.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 8

SanjayAttray (3/31/2010)
Hell, is there really a command like DBCC TIMEWRAP. Never heard of it and is now obvious never used.:-D
Even tried to google it and found nothing much. Though on a fluke got the answer right.

Congrats. It is extremely undocumented 😉

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

ziangij SSCrazy Eights Points: 8066 More actions · Answer 9

heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)

lucky to get 7 points.. 😛

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

ziangij (3/31/2010)
heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)
lucky to get 7 points.. 😛

Congrats. I better go check out that editorial.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

As long as the DBCC TimeWarp thread has been out there, you'd think more people would be getting this question right. :w00t:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Lynn Pettis (3/31/2010)
As long as the DBCC TimeWarp thread has been out there, you'd think more people would be getting this question right. :w00t:

Mildly surprising. Only 42 respondents though.

That is a really big clue though.

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

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 13

Had not even heard about it...damn did some googling and got the points...I just dint want to lose 7 points !!...hehe.

Thanks for teaching something new...!!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 14

Joy Smith San (3/31/2010)
Had not even heard about it...damn did some googling and got the points...I just dint want to lose 7 points !!...hehe.
Thanks for teaching something new...!!

Good job on finding the correct answer.

I would go back and re-read the source though.

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