Andrew J. Kelly

@DesertDBA Welcome to the area.

I’ve haven’t said much here lately because we’ve working for weeks on moving. North of the Phoenix area about 100 miles, into the “high desert” of Arizona. It’s quiet here, and the views aren’t too shabby.

@DesertDBA So sorry to hear that Jeff.

Feeling a bit off today. Amy & I are in the UK, and were up past 2am on the phone with our adult kids, as we all had to say goodbye to our ancient family member “Daphne”. Gutted we weren’t there for her, but so glad the kids all were. Daphne was truly one of a kind.

@kekline @jdanton @NedOtter If you need short down time why not do log shipping or Full / Diff restores. Then down time should be minutes.

@jdanton @NedOtter Bacpac might also be an interesting approach since they are often much smaller than a backup file. But I'm not sure how plausible it might be. #sqlhelp

What are some good strategies to reduce database size prior to moving the database, e.g. dropping unused/dup indexes, partitioning/archiving/deleting old data, data compression. What else am I missing? #sqlhelp

@GlennAlanBerry That is what happens when you get up too early on a holiday :). I was thinking QAT cards not ARC. Once we upgrade to SQL 2022 I want to put them in all the larger servers.

@GunneyK Why do you need a dozen of them? microcenter.com/product/660239…

Got these two open-box from Micro Center Denver, which was 20 percent off. Using a Micro Center credit card added 5 percent additional discount.

@Mike_WalshNH Some of us know what we want. Some don't

@GlennAlanBerry I definitely don't miss those days. Sounds like a good time for one of those home brews

It is minus 18.2 F right now in Elizabeth, CO. Luckily, the wind is nearly calm, so the wind chill is only minus 22 F.

@GFritchey Its a little bit of MA for your holiday adventures

Oklahoma is seriously broken.

@nicharsh Or just don't lay on the couch so much :)

@GlennAlanBerry That's a lot of fans Glenn. And like I said a lot of air. Enjoy that blowing in the wind feeling :)

@GunneyK If I was crazier, I could have mounted three more 140mm fans and two 120mm fans. But that would have messed up the looks and made it noisier...

This is my current main system.

@DesertIsleSQL I wish I could make it but have something else at that time. Good luck. It will be good to get back in person soon.

If you are available today, 9/14 at 5:30 PDT check out the Arizona Data Platform Users group where I will be talking on #PowerBI and #AzureSynapse ! meetup.com/arizona-data-p…

@jdanton Never mind. I found another CSV object group that had Sec/Write and it confirmed my suspicions that the CSV Latency is indeed in Seconds and is indeed very bad :). Thanks Joey. #sqlhelp

@jdanton For some reason the Physical disk perfmon counters are not showing write data includign disk sec/write (reads are just fine) and these are CSV's anyway. But the CSV write counters are either really good or really bad depending on if the latency is in Secs or ms :). #sqlhelp

Can anyone point me to documentation that states clearly if the IO Write Latency for a CSV File System perfmon object (Win 2019) is in ms or micoseconds. I just can't find any docs that actually state the metric interval. #sqlhelp

Sorry, I meant Seconds or ms,

@erinstellato Change is inevitable. Friendships can endure. I am sure you will excel at whatever you do. Good luck

A Fond Farewell sqlskills.com/blogs/erin/a-f…

@loriedwards Congrats. Enjoy

@GlennAlanBerry The only reason I can think of is if you knew for sure all of your calls were already done correctly to take advantage of plan reuse. But that would have to be one controlled environment.

I'm just curious what technical arguments/reasons would make you NOT want to use "optimize for ad hoc workloads"? One of the original MS Devs for the feature told me the only reason she could think of at an MVP Summit session back in 2008/2009... #SQLServer 1/2