« first day (4200 days earlier)      last day (37 days later) » 

5:09 AM
A chairde - Morning all!
 
 
6 hours later…
11:02 AM
morning
 
Morning
 
 
1 hour later…
12:15 PM
Morning
 
 
3 hours later…
3:33 PM
@Zikato The most common is with date/time string literals. Also important for converting hexadecimal strings.
For example, people can be surprised when trying to create an indexed view or computed column using a string date/time literal. Without CONVERT with a style you can get errors like:
> Msg 10139, Level 16, State 1
Cannot create index on view %s because the view uses an implicit conversion
from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style value.
After a while debugging stupid error messages due to a lack of coder precision, one learns to always use CONVERT with the right style parameter.
@ErikDarling Seems so. I have no special insight into how the new DMV is supposed to work. First I heard of it, and it's not documented yet either.
 
4:26 PM
@PaulWhite thanks
 
It was nice to see a video from you again
 
I hadn’t realized how long it had been since I looked at the dates on my last two videos
Felt pretty bad about that, heh
 
Time does fly by
 
5:12 PM
Today it should be renamed as MVPTwitter
Any new/renewal MVP here?
 
me! \o/
 
@Lamak Congrats !
 
5:32 PM
thanks!
 

« first day (4200 days earlier)      last day (37 days later) »