Thanks for sharing. 
You might also make a note about permissions. If the service account doesn't have appropriate permissions on the new path then SQL won't start.
I'd also stress...

Very interesting approach! Thanks for sharing.
One remark though: declare @value should probably read declare @val (in the first code fragment)
Regards
Thierry

Hi Kenneth, awesome article, thanks for sharing!
One question if I may... You mention reducing the amount of VLFs. Is that related to a specific wait? I know you could...

Hi Alex,
Spotlight (Quest) or SQL Monitor (Redgate) support mount points.
We use a custom utility. I've written a service that is installed on all SQL servers and that...

I think you should also configure the dependency between the "root" volume (P: in this case) and the mounted one because the mounted volume depends on it. At least that's...

This is an interesting article. Thank you for sharing!
What I'd like to know however is what causes this behavior. Seems like a bug, no? What version did you test...

This is very well written imho
https://www.codeproject.com/Articles/690340/Querying-SQL-Server-Part-I
https://www.codeproject.com/Articles/692269/Querying-SQL-Server-Part-II

It's indeed due to the different capitalization ( c: vs C: ). 
You need to change it in the registry where the service configuration is kept:  HKLM\SYSTEM\CurrentControlSet\Services. Find your instance...

A triathlon? Respect...

My goal is to run 365km this year. That doesn't sound like much to a pro but if you come to think of it: I may not be...

Thx!

Hi Igor,

thx for the interesting question. Do you have any thoughts on how hyperthreading relates to licensing?

Regards

Thierry

Jeff Moden (1/18/2016)

Any idea what...

Sure, at the risk of getting shot because of bad coding 😉

We have two helper functions converting from/to long/ip.

We subscribe to the datagrid's CellFormatting event and change the long...