Database Developer
Cambridge, MA
Joined May 2010
- Tweets925
- Following43
- Followers135
- Likes191
Robert Padilla retweeted
📬 Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training: ift.tt/NhaoCzS 📬
Robert Padilla retweeted
Learn how to manage cookies and custom headers, avoid TLS fingerprinting, recognize important HTTP headers, and implement exponential-backoff request retrying in #Python
jacobpadilla.com/articles/ad…
Robert Padilla retweeted
Google-Colab-Selenium: Use Selenium in Google Colab Notebooks! #python github.com/jpjacobpadilla/Go…
Robert Padilla retweeted
A comprehensive guide to handling async tasks in #Python
jacobpadilla.com/articles/ha…
Robert Padilla retweeted
Some extremely useful ways to use Chrome's Developer Tools:
jacobpadilla.com/articles/ch…
Robert Padilla retweeted
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)
#sqlhelp - running in Azure SQL Database - why would an "exists" cause a sort + hash match in plan?
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.
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 retweeted
[Article] Overlooked T-SQL Gems sqlperformance.com/2019/10/t…
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
#centralsquare @CambridgePolice bike unit went thru 2 red lights, did not stop for pedestrians in crosswalk. Weaves thru traffic with out signaling ride on sidewalk to meet fellow police in front of city hall. Please have bike unit follow rule/law. #DoBetter #leadbyexample
Does any one have a quick explanation or link for what does "LOB_COMPACTION" does with reorganize? I am thinking it just consolidates data into fewer pages (no compression). How useful is this if you are not updating LOB data? #sqlhelp
I have a query like:
select TOP (1) a, b, c, d from table where a = 1 and b = 0 order by c desc, d desc
I have index as: a, b, c desc, d desc.
I get a seek but my logical reads change from 4 to 800. Why would cause the extra logical reads? Snapshot Isolation is on. #sqlhelp
Robert Padilla retweeted
Suggestion to improve SQL Server - Add support for Row Pattern Recognition in T-SQL feedback.azure.com/forums/90… Add your vote!
Robert Padilla retweeted
[Article] T-SQL bugs, pitfalls, and best practices – determinism sqlperformance.com/2019/03/t…
Robert Padilla retweeted
Finally finished the migration of my #SQLblog content to sqlkiwi.blogspot.com/ 😊
Robert Padilla retweeted
Hey Boston, wanna learn some horrible things about SQL Server?
buff.ly/2E31CV8
Let's get weird on May 10th!
cc: @NESQLServer