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! Vancouver, BC Joined October 2011

Tweets

449
Followers

107
Following

98
Likes

47

Diane @sql2go

4 years ago

If anyone is interested please let me know! linkedin.com/posts/activity…

0 0 0 0 0

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

5 1 2 0 1

Diane @sql2go

6 years ago

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?

Diane @sql2go

6 years ago

1 0 0 0 0

Download Image

0 1 0 0 0

Diane @sql2go

6 years ago

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

1 0 0 0 0

Download Image

Diane @sql2go

6 years ago

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

0 0 1 0 0

Diane @sql2go

6 years ago

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

0 0 0 0 0

Diane @sql2go

7 years ago

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…

1 0 0 0 0

Diane @sql2go

8 years ago

#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…

1 0 0 0 0

Diane @sql2go

8 years ago

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