@KillaXBT I have a hypothesis for the abnormal price action. The new usage of AI trading bots and some fresh institutions might not be aware of the structure and with low trading volume they get more power over the price than they would otherwise.
@jadesola_anoma Lern how to use CTE and APPLY. It will save you much time in building effective queries. Focus on python functions for production grade machine learning. Good luck in your endeavors.
@chrishoina @OracleSQLDev@OracleDatabase@OracleREST Some cities in the world share the same name. You would need a country and probably a province/state column as well and a unique constraint on the combination of these columns in the table to ensure future updates and inserts are not causing duplicates. #sqlhelp
@JohannesVink@AngryPets Is it necessary to handle your ISO year needs in sql? If e.g. Power BI is your reporting tool you can handle it with DAX and a date table. #sqlhelp
@ShaunRAustin Because it's saying: "Hey, I'm READING here!" (don't gum-up the rows I'm running, say, aggregations or calculations against by INSERTing, UPDATEing or DELETEing rows 'out from under me' _WHILE_ I'm reading this range; I ONLY want COMMITTED changes so NO CHANGES while I'm reading.
@tradney The tool that I would use is checking which reports are really valuable still and what the customers really need now since the requirements ought to be updated when migrating to a new reporting platform with so many new features and visualizations. #sqlhelp
@ReddTrain Perhaps there is someone at your company that you can pair with fir python. If it is a one time shot you can do it in a python3 notebook using def as functions to call from for and while loops. Without knowing the scope I would go for it but perhaps adapting the cursor is faster.
@RohitKu2311 It sounds like this function is a good candidate for refactoring. Probably some of the complex work can be lifted to ETL so that your function can get less levels and also get rid of the view. #sqlhelp
@databaseguy Saving a few key strokes is not worth it if readers get confused. DAG is a common acronym for directed acyclic graph used in e.g. automation of jobs and causal inference. #sqlhelp
@tjaybelt Hi TJay, It seems like the long term problem needs to be addressed as well. It is not ok that an upgrade is done without checking current activity nor communicating the planned upgrade date in advance.
@Riskworks IMHO it makes more sense to debug when efficient to do so in a tool connected to git or tfs rather than ssms but my viewpoint is a developer’s, not a DBA’s. #sqlhelp
@Elaena_Bakman You need enough columns in the order by clause to make each row unique for these columns to guarantee order in the result. See https://t.co/y65hn3KZii #sqlhelp
@SQLDeployHelmet What has worked for me in cases like this is rewriting source query manually with any casts or order you might need to avoid doing advanced mapping editing. Then go through editing all transformations from Step 2 to Destination to restore mappings to normal. #sqlhelp