Uber kudos for not deploying a prerecorded opening for your videos. I find I look forward to whatever unique shannanegans you’ll open with, not to mention the always possible chance for some random belly holding cough up my coffee humor highly likely to ensue. And your content is nice too. What I never suspected was you obtained beer-gut magazine certification. Way to go beer-gut buddy!
@ErikDarlingData
29 күн бұрын
The Beer Gut Magazine certification is my proudest accomplishment. Some people still talk about being an MCM like it’s a big deal they had 20 grand and nothing to do for three weeks in 2010. How bizarre.
@pearcegrinnell1809
Ай бұрын
Wow that is definitely interesting. Thankfully I have never mixed these datatypes.
@ErikDarlingData
Ай бұрын
It’s a bad time, hahaha
@user-zr6zy1bn5j
Ай бұрын
That’s interesting and more informative, thanks for posting
@ErikDarlingData
29 күн бұрын
Glad you enjoyed it. It’s definitely an oddball thing.
@Chompingbits
28 күн бұрын
Bashing keys uselessly is my job title though!
@ErikDarlingData
28 күн бұрын
Distinguished Key Basher I’m sure!
@FlaggedStar
29 күн бұрын
This is the only behaviour change that comes with changing compatibility levels that I expect anyone to actually notice. I've done a lot of 90 to 150 conversions.
@ErikDarlingData
29 күн бұрын
Really? Nearly every emergency help email I get is someone who moved to a higher compatibility level and had a total meltdown.
@FlaggedStar
29 күн бұрын
@@ErikDarlingData Yeah. Just behaviour, mind. Not performance.
@cartercordingley6062
28 күн бұрын
Hey, this is really useful information, thanks! My thoughs, I know that datetime only works from 1753 (the first full year after the Gregorian calendar was adopted in Europe, Asia, and America). Also, the Microsoft documentation says that datetime shouldn't be used, and that it's more of an issue with C# LINQ that needs to be updated to use datetime2 instead of datetime. I also noticed that datetime has a time range of 00:00:00 through 23:59:59.997, so I'm wondering if this is only a problem when it's in the .003 range. Further down in the document, it says that datetime has an accuracy rounded to increments of .000, .003, or .007 seconds. I've never really looked at the documentation for datetime past the first bit. I think someone needs do some searching to see if there's a C# bug to vote on for an update to use datetime2, since the Microsoft documentation says not to use datetime. Also I wonder how these examples would handle datetimeoffset type
@ErikDarlingData
27 күн бұрын
Oh, yeah, the documentation for datetime is kind of fascinating. The deeper you go the weirder it gets. I suppose the main takeaway is to not mix and match data types. You get what you pay for when you go down that path.
@DanielMaenle
27 күн бұрын
Not the best at getting functionality But with the index issue. Curious if a table spool create would cause the issue as well
@ErikDarlingData
26 күн бұрын
Probably not a table spool, but potentially an index spool
@DanielMaenle
26 күн бұрын
@@ErikDarlingData Joys for random data to return then . .....
Пікірлер: 21