3
votes
Managing very large VLF
Is there a way to get rid of this large VLF [...]
The only way is to shrink the log to remove the VLF.
[...] what the implications of having such a large VLF.
It stays active for a long time and ...
1
vote
Masking data for SA users
As far as I'm aware if you need to hide data from everyone, including SA/Sysadmins then there's only 1 real option.
Always Encrypted (Microsoft Learn | SQL)
Always Encrypted is a feature designed to ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2017 × 1012sql-server × 806
availability-groups × 104
performance × 50
sql-server-2016 × 40
linux × 40
backup × 38
t-sql × 36
ssms × 33
query-performance × 26
execution-plan × 23
installation × 23
stored-procedures × 22
restore × 22
ssis × 20
replication × 19
index × 19
upgrade × 19
clustering × 18
sql-server-2019 × 18
sql-server-2012 × 17
permissions × 17
sql-server-2014 × 15
partitioning × 15
memory × 15