We have some calls like that. I often join a US sales happy hour Thur afternoon and we have a random assignment call Fri am for the UK.

However, these aren't...

I'm still not sure I know this. I need to practice a bit more and write a few more questions to test myself.

We're finding that as well. I'm hoping we try something to help random conversations. We've talked about leaving a meeting open for people to randomly join.

It is

Could this be concurrency somehow? A SELECT should have an implicit transaction during which it runs, so I'm not sure why this changes things.

AFAIK, xp_fixeddrives hasn't been supported for some time. Other XPs are.

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/general-extended-stored-procedures-transact-sql?view=sql-server-ver15

dm_os_volume_stats is what I'd use.

I loved cycling for one job, about 10 miles and mostly separated from traffic. Only a couple scary spots. Before that I had a 12mi cycle, but it was on...

For good auditing, the service account should have a file location that only allows write access for this account. read should be from another account, usually the auditors/security staff.

Daylight is nice. I know that I enjoyed having my blinds open in the winter. Now, it's too hot with a South facing window and the office is dark most...

Please feel free to submit an article (or more than one) here: https://www.sqlservercentral.com/contributions

You'll get paid and I'm sure others will be interested.

Are you asking inside of SQL Server, as in T-SQL, or from the host OS? How do you get this in Windows?

df in Linux gets space. or du.

Some things can be affected, some not. It depends if the underlying part of the system (SSMS or SQL), refers to the item by name or by SID. The SID...

This would be a great series of articles, if anyone wants to write a few pieces.

Quite a routine. You're more disciplined than I am. How long did it take you to build this routine?

I know it took me 3-4...

Quite a routine. You're more disciplined than I am. How long did it take you to build this routine?

I know it took me 3-4...