Date Predence

Question

Post reply

Date Predence

Steve Jones - SSC Editor

SSC Guru

Points: 737424
More actions
June 24, 2015 at 10:37 pm

#74517

Comments posted to this topic are about the item Date Predence
June 25, 2015 at 3:23 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

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

Shiva N Hall of Fame Points: 3125 More actions · Answer 1

Thanks allot,

Nice question...

Shiva N

shivasssv@gmail.com

Thanks,
Shiva N
Database Consultant

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

Umer Akram

SSC-Insane

Points: 22209

June 25, 2015 at 1:06 am

#1807946

good question. thanks for sharing

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 3

Easy one, thanks.

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

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 4

Thanks for this easy question ( I got a similar question during an interview and I remembered that I hesitated only for the choice between Date and Time ).

George Vobr SSChampion Points: 10048 More actions · Answer 5

Thanks Steve. A simple question with unexpected consequences. For me, it was to repeat the lessons about usages of the CONVERT_IMPLICIT functions and the related performance issues.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Nice and simple, but with major impact. Thanks, Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

free_mascot One Orange Chip Points: 27164 More actions · Answer 7

Easy one, Thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

OK, had to look it up. Got confused about smalldatetime.

TomThomson SSC Guru Points: 104773 More actions · Answer 9

Nice question.

I particularly liked the last option as a distractor because people might be termpted by the only option including all the dat/time related times.

Tom

Arno Kwetters Hall of Fame Points: 3869 More actions · Answer 10

Arno Kwetters

Hall of Fame

Points: 3869

June 26, 2015 at 3:27 am

#1808338

Good choose of answers.

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

TomThomson (6/25/2015)
Nice question.
I particularly liked the last option as a distractor because people might be termpted by the only option including all the dat/time related times.

Yep.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

psingla Hall of Fame Points: 3840 More actions · Answer 12

Koen Verbeeck (6/25/2015)
Easy one, thanks.

+1

Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/

Date Predence

Cookies on SQLServerCentral