« first day (321 days earlier)      last day (368 days later) » 

Joe Obbish
Joe Obbish
12:16 AM
3
Q: Non-standard number data types in Oracle

OialeI'm not sure that this question belongs to this StackExchange. I've asked this question on StackOverflow: Besides the "usual" number data type where precision is greater then scale there are many "non-standard" number data types where scale greater then precision or where scale is negative...

oracle database-design datatypes
@sp_BlitzErik that one might float your boat
 
sp_BlitzErik
sp_BlitzErik
Is that a uterus?
 
Joe Obbish
Joe Obbish
I don't think that those wear hats, but I'm not an expert
 
 
3 hours later…
jadarnel27
jadarnel27
3:16 AM
"I'm not an expert" - Joe Obbish
2
Are we still doing that?
 
Joe Obbish
Joe Obbish
I never claimed to be an expert
 
jadarnel27
jadarnel27
3:31 AM
Well you should.
 
 
10 hours later…
Lamak
Lamak
1:05 PM
@sp_BlitzErik and now?
 
sp_BlitzErik
sp_BlitzErik
sort of, about to take kid to school
what's up?
 
Joe Obbish
Joe Obbish
1:34 PM
@sp_BlitzErik does she ride on your shoulders while you fight off bums?
 
Lamak
Lamak
1:44 PM
@sp_BlitzErik can't run sp_blitzQueryStore :(
 
jadarnel27
jadarnel27
Did you ever determine if your database collation and server (instance) level collation match or not?
 
sp_BlitzErik
sp_BlitzErik
@Lamak great bug report?
 
Joe Obbish
Joe Obbish
turn that frown upside down
 
sp_BlitzErik
sp_BlitzErik
does anyone have a job i can do where i don't have to work?
 
Forrest
Forrest
2:00 PM
sorry, not aware of any unions you can join
5
 
Lamak
Lamak
@sp_BlitzErik don't know
maybe it's because I'm doing something wrong
 
sp_BlitzErik
sp_BlitzErik
alright, cool, can you file a github issue with whatever is going on?
i'm on a client call for a while
 
Joe Obbish
Joe Obbish
2:39 PM
Texan detected
 
 
3 hours later…
Joe Obbish
Joe Obbish
6:06 PM
everyone is working too hard today
 
Joe Obbish
Joe Obbish
6:23 PM
 
Forrest
Forrest
welp, there goes New York
 
Joe Obbish
Joe Obbish
I bet erik is buying some right now
 
Forrest
Forrest
It's a slippery slope. A state forced to let citizens tie sticks together might be forced to let them do something truly dangerous, like vote.
 
sp_BlitzErik
sp_BlitzErik
7:16 PM
i remember the good old days when you could buy all sorts of contraband from stores in chinatown
brass knuckles, pepper spray, butterfly knives
 
 
1 hour later…
Forrest
Forrest
8:37 PM
I finally finished the M-M Merge! It's complicated.
user image
5
 
jadarnel27
jadarnel27
8:51 PM
Kendra touched on this with tempdb, not sure it'd be an issue for you but wouldn't hurt. — scsimon 38 mins ago
Calling Tara "Kendra" is the new calling everyone "Brent?"
@Forrest 🤯
 
sp_BlitzErik
sp_BlitzErik
9:24 PM
@Forrest a trifle too satanic
 
Forrest
Forrest
you're right, I completely forgot the pentagrams
 
 
2 hours later…
Paul White
Paul White
11:45 PM
The risks of using a trace flag with a 4 in it: support.microsoft.com/en-us/help/4089239/…
Another win for agile development: support.microsoft.com/en-us/help/4458157/…
 
sp_BlitzErik
sp_BlitzErik
they should try devops
 
Paul White
Paul White
Pretty much every issue fixed in CU13 was caused by devops
Anyone remember the days when retail assertions were rare?
 
Joe Obbish
Joe Obbish
never trust 7412
@PaulWhite no, I'm young
 
sp_BlitzErik
sp_BlitzErik
lol
tell us another one, rummy
 
Paul White
Paul White
@JoeObbish Good job it's not default for any new products
I suppose I hadn't appreciated that "lightweight" applied to the testing effort
 
sp_BlitzErik
sp_BlitzErik
11:53 PM
lmao
 
Paul White
Paul White
sigh
 
sp_BlitzErik
sp_BlitzErik
wtf
> Improvement: You can set the minimum interval value to less 10 seconds for parallelly running SSIS packages in SQL Server 2017
> parallely
> mfw
 
Paul White
Paul White
so much fail in one CU
good job none of us work with xml extensively
or parallely
 
sp_BlitzErik
sp_BlitzErik
ctrl + f access: 8 hits
 
Paul White
Paul White
maybe all the testing effort is busy with 2019
 
sp_BlitzErik
sp_BlitzErik
11:56 PM
ctrl + f assert: 2 hits
ctrl + f error: 16 hits
 
Paul White
Paul White
ctrl + f useful details: no hits
 
sp_BlitzErik
sp_BlitzErik
ahem
you can expect these to be tested with the same rigor
copious rigor
 
Paul White
Paul White
all our CUs are rigorously tested and documented by interns (that we sacked last year)
 
sp_BlitzErik
sp_BlitzErik
tanned, rested, and ready
 
Paul White
Paul White
go team!
 
sp_BlitzErik
sp_BlitzErik
11:59 PM
i hope they're tested paralelly
 
Paul White
Paul White
😃
 

« first day (321 days earlier)      last day (368 days later) »