From the Article:
...Microsoft does, as do lots of organizations trying to embrace DevOps and produce higher quality...
Ok... you caused me to blow a pork chop bone out of my nose while I was reading this. Look at Pivot, Format, String_Split, String_Escape, DATEDIFF and DATEADD (basically zero ISO support), CONVERT (no support for durations/periods or thousands separators for whole numbers), DECIMAL math (4 function calculator works better), DATEDIFF_BIG (a "Fix" for the mistake they made on the newer temporal datatypes instead of fixing the original problem), XML as a whole (hole is a better term), Partitioned Tables, Recursive CTEs, INSTEAD OF Triggers, CEIP (total invasion of company and personal privacy), SSRS, SSIS, script generation (they have code that does it but we can't execute it), xp_ and sp_ objects, Creating EOM with no FOM, no sequence generator (fnTally type) even after 11 years, an ISO date format that isn't right for certain languages, broken newer temporal datatypes that no longer meet ISO standards, the changes in SSMS since it became a separate product, DBCC SHRINKFILE, Index REORGANIZE, usage examples in MS Docs, safety in SP and CU releases, HierarchyID, the mess they made by defaulting LOBs to in-row in 2005, deprecation of useful features just because they no longer want to support them, lack of support of useful built-in features because they don't want to support them, Fast Inserts, the Cardinality Estimator "improvement", GUIDs that are no longer globally unique, etc, etc, etc, and understand why I had such a gut wrenching and violent laugh at that comment. And don't get me started on O-365, or what they did to Visio and that whole.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)