Learn how to manage cookies and custom headers, avoid TLS fingerprinting, recognize important HTTP headers, and implement exponential-backoff request retrying in #Python
https://t.co/zCg54NdNd7
Please don't use Asyncio.sleep(0.1) in #Python to yield control to the event loop. There's a method in the CPython source code specifically for asyncio.sleep(0)
@Hugo_Kornelis@SQL_Kiwi So today - it is working as expected :)
It must have been stats
I am using Azure SQL Database - with comp level = 150.
Thanks for reaching out.
@Hugo_Kornelis@SQL_Kiwi These tables are large, I wonder if it could be stats related - I will look into that. Will see if I can make a repo. This does not happen on all the cases - so will see if I can find root cause.
In sys.indexes what does column "is_ignored_in_optimization" used and or set? Seeing this on Azure SQL Database #sqlhelp I was unable to find anything useful during searching.
@sqL_handLe Yes non clustered, only 1 value. I looked at other indexes in this table and most do go parrallel with rebuild. But a handful don’t. And no pattern I see.
Anyway to force it to go parrallel?
@sqldbawithbeard great session at #PASS. Really well done. Had a question a little off-topic, if there is a way to do "excel" stuff to export to google sheet? Thanks.
Can someone please explain how table variable is estimating more than 1 row? There is no OPTION (Recompile), there is no TF 2453. There is a PK Clustered on ID. #sqlhelp