How to sanitize decimal numbers to the Nth decimal place without rounding.
For example, if you are dealing with crypto numbers like BTC (Bitcoin) or ETH (Etherium).
https://gist.github.com/Protiguous/14d51ba097783f249f1f3b441ed82674#file-sanitize-cs
Longer lines of code are faster.. eh?
I mean, I did have another programmer vehemently argue once long ago that putting more code on one line would make it “run faster.” But of course he was stark raving nuts. Trying to explain to him (with a straight face–which was challenging) how the interpreter or compiler would break that long line apart into discrete one-instruction-per-line statements–essentially identical to the result if he had gone ahead and just made the code readable instead of trying to out-clever the compiler–had no effect on him whatsoever. But I digress.
Craig Tullis on a StackOverflow answer.
Premature optimization is the root of all evil.. NOT!
We should forget about small efficiencies, say about 97% of the time: premature optimization is the root of all evil. Yet we should not pass up our opportunities in that critical 3%.
Famous computer scientist Donald Knuth
His quote is often clipped down to just “premature optimization is the root of all evil”, but that is NOT TRUE.
Yes, don’t micro-benchmark everything when you begin a project, but please do think ahead. And once you’ve got the program working as intended, then make it faster by profiling and looking for the bottlenecks.
Choose the proper data structures. Array? List? Hashset? Queue? Dictionary? Caching?
Take a few moments and think it over.
How often will this line of code be ran? Do I need to inline it, or pull it out into a separate method?
100 Darts Conspiracy
If you throw 100 darts and only 1 hits the bullseye, it doesn’t mean you’re good at darts.
Re: people spouting conspiracies constantly.
Programming 102, Subsection 3, Paragraph 7
Get it working.
Franks2000InchTV
Then get it working correctly.
Then get it working fast.
Then get it working fast correctly.
Mike Lindell: Secretly an idiot.
He has the haunted look of an idiot who secretly knows he’s an idiot pretending not to be an idiot.
Protiguous, 2021. Talking about Mike Lindell’s claims that the 2020 election was stolen from Donald Trump.
List Databases with a different collation than the SQL Server
select
[d].[name] [Database Name]
,databasepropertyex( [d].[name], 'COLLATION' ) [Database Collation]
,serverproperty( 'COLLATION' ) [Server Collation]
from [sys].[databases] [d]
where ( databasepropertyex( [d].[name], 'COLLATION' )) != serverproperty( 'COLLATION' );
List collation on all columns in all tables in database on SQL Server
select
concat( quotename( [s].[name] ), N'.', quotename( [t].[name] ), N'.', quotename( [c].[name] ) ) [Column Name]
,[c].[collation_name] [Collation]
from [sys].[schemas] [s]
join [sys].[tables] [t] on [t].[schema_id] = [s].[schema_id]
join [sys].[columns] [c] on [c].[object_id] = [t].[object_id]
where [c].[collation_name] is not null
order by [Column Name];
Example:
Borders
Borders don’t make you any safer.
Protiguous, 2021
Borders only keep out potential friends.
Concat two enumerables
public static IEnumerable<T> Concat<T>( this IEnumerable<T> left, IEnumerable<T> right ) {
foreach ( var a in left ) {
yield return a;
}
foreach ( var b in right ) {
yield return b;
}
}
