
Adjusting Views to Reduce Visibility of Data in MySQL
Let us consider a table representing employee data with a few columns, and, of course, their salary details as well.
Let us consider a table representing employee data with a few columns, and, of course, their salary details as well.
It is quite easy to find the error log location through a quick query such as : SELECT SERVERPROPERTY(‘ErrorLogFileName’) AS ‘Error log file location’ This shows where your Error log file is stored
DBCC SHRINKDATABASE The command shrinks the size of the data and log files in a database. Here is a small example: DBCC SHRINKDATABASE (Database_Name, 10); –This allows for 10 percent free space in the database.
You can use the following command to monitor all your databases’ log file’s free space DBCC SQLPERF (‘LOGSPACE’)