Robert Padilla

Database Developer

[Darling Data @erikdarlingdata]

📬 Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training: https://t.co/KcJqRv7bnd 📬

[Jacob Padilla @jpjacobpadilla]

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

[Real Python @realpython]

Google-Colab-Selenium: Use Selenium in Google Colab Notebooks! #python https://t.co/iRt7IEPSMa

[Jacob Padilla @jpjacobpadilla]

A comprehensive guide to handling async tasks in #Python

https://t.co/WBQaaeu9O5

[Jacob Padilla @jpjacobpadilla]

Some extremely useful ways to use Chrome's Developer Tools:

https://t.co/A2jMSLJp9v

[Jacob Padilla @jpjacobpadilla]

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)

[Robert Padilla @RPsql]

@Hugo_Kornelis First time working with Azure and realizing that since don't have to patch, changes can happen day to day :)

[Robert Padilla @RPsql]

#sqlhelp - running in Azure SQL Database - why would an "exists" cause a sort + hash match in plan?

[Robert Padilla @RPsql]

@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.

[Robert Padilla @RPsql]

@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.

[Robert Padilla @RPsql]

@sql_r Thank you

[Robert Padilla @RPsql]

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.

[Robert Padilla @RPsql]

@BostonCodeCamp When do you plan on opening registration?

[Robert Padilla @RPsql]

Thanks will look at that and test

[Robert Padilla @RPsql]

Why would an idx rebuild NOT go parallel?
Idx ~ 30GB, > 1B rows, 1 key of varchar, nothing included. Settings
with (online = ON (wait_at_low_priority ( max_duration = 10 minutes, abort_after_wait = self )), maxdop = 8, sort_in_tempdb = ON);
No resource governor
#sqlhelp

[Robert Padilla @RPsql]

@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?

[Robert Padilla @RPsql]

@johnsterrett @Apress @GFritchey @bobwardms @auntkathi I like the idea

[Robert Padilla @RPsql]

@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.

[Itzik Ben-Gan @ItzikBenGan]

[Article] Overlooked T-SQL Gems https://t.co/OBdAg366DO

[Robert Padilla @RPsql]

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