Diane
@sql2go
DBA by trade... No really, wanna trade? Unfortunately, I've only achieved 66.66% uptime, my system continually crashes between 12-6 am. Maybe I need a patch!
قد يعجبك
Hey friends! Want to work somewhere exciting and fun? Great colleagues and perks? Make a difference in helping people find love and connection? Then check this out & apply or let me know if you want more info #sql #BigData #aws #sqlserver #databricks join.matchgroupcareers.com/careers/job/30…
If anyone is interested please let me know! linkedin.com/posts/activity…
Why does a 3000 line row-by-row INSERT script perform better with a GO after each statement than without? Script is only 481KB and takes a few seconds with GO and a few minutes without. It can’t all be parse/compile? #sqlhelp
Even though it's a pretty tiny read, it is executed hundreds of of times per second. Changing the FILLFACTOR from 100 to 80 resulted in either no change or slightly worse performance. Original tables did contain 50% fragmentation. Would like to know what else could be a factor?
#sqlhelp I have a query plan which doesn't change after an index rebuild incl. costs, rows, row size, etc. Even though reads & writes remain the same, worker time increases (0.1 to 0.6 ms). Reads are 99.9% logical reads, and back-end storage is high-end SAN. Any explanations?
#sqlhelp I have a query plan which doesn't change after an index rebuild incl. costs, rows, row size, etc. Even though reads & writes remain the same, worker time increases (0.1 to 0.6 ms). Reads are 99.9% logical reads, and back-end storage is high-end SAN. Any explanations?
Vancouver PASS Chapter Meetup August 2019 - Power BI Report Server: a Deep Dive by Luca Gualtieri, Co-founder & CTO PBILab this Thursday. Sponsored by #POF and our very own @SQLSocialite Don’t miss out, RSVP and details at vancouver.pass.org! #SQLServer #sqlpass #PowerBI
#sqlhelp optimizing indexes showed interesting impact when rebuilding sometimes: logical reads, worker time cut in half, but elapsed time doubles anyways. Could this be stats? No blocking wait diffs. Same test workload. Difference is use of parallelism.
If anyone is interested or knows someone who is, please pass them on to me for filling some careers. I can definitely vouch for how great it is to work at POF! Check it out here: #careers #businessintelligence #itdevelopment #itmanagement #poflife pof.com/careers.aspx?a…
#sqlhelp. I’ve reposted this question more clearly here about possible issue with DMV perf of dm_exec_query_stats: dba.stackexchange.com/q/202948/94927…
#sqlhelp weird issue with job to collect from dm_exec_query_stats INNER JOIN sys.dm_exec_cached_plans CROSS APPLY dm_exec_sql_text suddenly jumped in reads, writes, and cpu time 10x. No changes to code. Seems like autostats issue but how can it be fixed?
#sqlhelp weird issue of blocking where lead blocker on sp_whoisactive involves different table then the one blocked, and open_tran_count=0. Checked SP and app code and no explicit trans. What else could it be?
No we just impl. RG and moved on. It's been a week now and memory hasn't grown nor page life expectancy dropped since.
Yup, strange but true. We have 6TB of RAM, and memoryclerk_XTP consumed over 5TB, eventually paging out the buffer pool thrashing PLE too
Since RG is only in Ent. Ed., seems strange that it would be required. GC does not work for in-mem tbl variables only in-mem tbls.
We used to replace highly active user tables to queue notifications via push/pop. Ins/del ops mostly. Some table variable usage as well.
Would love to hear more about how you are using In-Mem in your environment. Tmp table replacement? User tables also?
United States الاتجاهات
- 1. #JoyForum 1,486 posts
- 2. #2025MAMAVOTE 343K posts
- 3. Good Thursday 20K posts
- 4. Brevis ZK 141K posts
- 5. Mila 18K posts
- 6. Deport Harry Sisson 12.9K posts
- 7. Friday Eve N/A
- 8. #MC필릭스의_냉터뷰 13.5K posts
- 9. MC FELIX FRIDGE INTERVIEW 14.6K posts
- 10. #FridgeInterview_MCFelix 13.8K posts
- 11. #thursdaymotivation 1,784 posts
- 12. Tomonobu Itagaki 7,524 posts
- 13. Deloitte 9,463 posts
- 14. Ninja Gaiden 12K posts
- 15. BNB Chain 20.7K posts
- 16. DuPont 2,129 posts
- 17. Dead or Alive 10.8K posts
- 18. Pelosi 148K posts
- 19. Mad Max 4,519 posts
- 20. John Fetterman 30.1K posts
Something went wrong.
Something went wrong.