Database Developer
Joined May 2010
- Tweets 927
- Following 43
- Followers 136
- Likes 196
52 Photos and videos
Robert Padilla retweeted
4 Mar 2024
📬 Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training: ift.tt/NhaoCzS 📬
1
2
309
Robert Padilla retweeted
28 Feb 2024
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…
6
17
3,046
Robert Padilla retweeted
23 Feb 2024
Google-Colab-Selenium: Use Selenium in Google Colab Notebooks! #python github.com/jpjacobpadilla/Go…
12
53
7,071
Robert Padilla retweeted
14 Feb 2024
A comprehensive guide to handling async tasks in #Python
jacobpadilla.com/articles/ha…
7
15
2,407
Robert Padilla retweeted
11 Feb 2024
Some extremely useful ways to use Chrome's Developer Tools:
jacobpadilla.com/articles/ch…
1
1
465
Robert Padilla retweeted
11 Feb 2024
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)
1
3
5
1,281
30 May 2023
#sqlhelp - running in Azure SQL Database - why would an "exists" cause a sort hash match in plan?
2
673
22 May 2023
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.
1
100
8 Feb 2023
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
2
252
Robert Padilla retweeted
9 Oct 2019
[Article] Overlooked T-SQL Gems sqlperformance.com/2019/10/t…
2
26
50
5 Sep 2019
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
1
4 Sep 2019
#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
1
1
1
2 Jul 2019
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
1
23 May 2019
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
3
Robert Padilla retweeted
1 Apr 2019
Suggestion to improve SQL Server - Add support for Row Pattern Recognition in T-SQL feedback.azure.com/forums/90… Add your vote!
11
18
Robert Padilla retweeted
13 Mar 2019
[Article] T-SQL bugs, pitfalls, and best practices – determinism sqlperformance.com/2019/03/t…
22
32
Robert Padilla retweeted
2 Mar 2019
Finally finished the migration of my #SQLblog content to sqlkiwi.blogspot.com/ 😊
9
45
Robert Padilla retweeted
9 Feb 2019
Hey Boston, wanna learn some horrible things about SQL Server?
buff.ly/2E31CV8
Let's get weird on May 10th!
cc: @NESQLServer
2
3
17