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. #2025MAMAVOTE 961K posts
- 2. $ZOOZ N/A
- 3. #ThursdayThoughts 1,921 posts
- 4. #thursdayvibes 2,783 posts
- 5. Good Thursday 29.3K posts
- 6. Mila 17.8K posts
- 7. #TOMORROWXTOGETHER 47.1K posts
- 8. Deport Harry Sisson 18.6K posts
- 9. Deloitte 12.8K posts
- 10. Ninja Gaiden 18.8K posts
- 11. #NJCAADay N/A
- 12. Dead or Alive 16.6K posts
- 13. Happy Friday Eve N/A
- 14. Itagaki 20.5K posts
- 15. DuPont 2,442 posts
- 16. No Kings 140K posts
- 17. Jennifer Welch 6,001 posts
- 18. Starting 5 7,201 posts
- 19. Bernie 44.5K posts
- 20. Andrade 5,218 posts
Вам может понравиться
Something went wrong.
Something went wrong.