Personally - I would not do this on the SQL side.  The ONLY way I can think of to do this would be with dynamic SQL and to me that...

My opinion - every time I've seen an "unable to delete" error, or unable to copy, move, archive, etc, it has been due to disk failure.  I would run a...

• This reply was modified 3 years, 10 months ago by Mr. Brian Gale.

I wish my disk latency was down as low as 8ms... my lowest read stall is 11ms and the highest is 265869 ms; mind you that DMV is showing you...

I think it depends on your source.  I am assuming this is still the TAR source, in which case you would just need to treat it like a bunch of...

• This reply was modified 3 years, 10 months ago by Mr. Brian Gale.

What command are you using for tar?  If you are using the native tar built into windows 10, then you would run:

tar -tf <archive name>

which will give you the contents...

Have you tried unpausing it?

Personally, I am not a big fan of activity monitor.  It shows information in one nice dashboard, but even some Microsoft employees recommends against - https://redmondmag.com/articles/2021/08/25/activity-monitor-sql-server-performance.aspx.

I...

I had some "fun" last night trying to get into my playstation account with 2FA turned on.  Enter username and password, next it tells me it sent a text to...

Maybe I'm a bit out to lunch here, but those read stalls look pretty small.  1000 ms is 1 second, so your read stalls on the primary and secondary average...

One other thought - is the folder a network share?  If so, you will need to use the FQDN path to the location (ie //server.domain.com/share/path) rather than the letter (ie...

NOTE - the below is based on my understanding of your code and doing a quick translation into C# as I know C# a bit better than the language you...

My thoughts - a database should be used when you need to have a centralized location for shared data for medium to long term storage for data.  With exceptions.  I...

At times it is really nice because you have the freedom to do the full development from end to end, but at other times it is painful because you start...

Since you are able to get the full name which is half of your battle.  I see multiple approaches to this, none of which are "pretty".

The most supportable approach I...

I agree... Our walls are low, but they still exist.  And in some cases they should exist.  For example, you wouldn't want me mucking around with AD or spinning up...

Quick check online, masks are applied at the table level, not the view level. So to answer question 1 no you cannot use the built-in masking function on a view...