What was the average percent of page fullness both before and after you started?  I can show you how to make better estimates with that information and with knowing what...

I've always been frustrated by things like that.  It's a complete tease that MS built into the system.  My answer has always been to use xp_CmdShell for such things... and,...

My recommendation is just buy some more SSD.  Maybe even buy some less expensive spinning rust where you can move some filegroups to for things like audit tables and the...

Can you kindly tell us what you figured out?  It'll help other folks (and me 😉 ). Thanks.

"Do not be afraid to ask questions"

I think this also applies to: Do not be afraid to post your anwers and solutions here on the forum.

Even if it is...

I've found that Full Backups are taken through a snapshot of the VM itself within Azure and in return it breaks the log chain. That was what started my...

I've used it to troubleshoot, wondering if two connections had different settings. Getting a raw number and comparing them worked for me. I haven't really used this to decode...

Thank you Jeff. Yes I am painfully aware that the code is different. It took me a very long time to figure out the SQL query and am really...

Thanks Grant/Jeff, that is exactly my methodology as well that I just wanted to confirm.

What do you both do surrounding the VM backup, because if you have the "SQL...

And surrogate keys can and usually are durable keys.

that would only work on a very small environment right? I've got 64 prod servers and nearly 200 total including non-prod, and the number of times in the last...

Tell people where you work that you've been there for 8 years and that you'd like to shift to the day shift.  The answer is no unless you ask.  If...

You do understand that you're making a major paradigm shift in code, right?  SQL <> SQL between different RDBMS engines.

A lot of people will disagree with me on many fronts but I always keep an active SSMS session running in an RDP session on my production servers.  It has...

"It Depends".  On my main production server, the...