Useful SQL command to reduce the size of the database
今日想和大家分享一個 幾有用的TSQL Command, 去 Release 返一些SQL Server 佔用的空間 Transaction log 和Database file -- select database USE Production; -- Change the recovery mode to SIMPLE, to clear the …
•
1 min read
今日想和大家分享一個 幾有用的TSQL Command, 去 Release 返一些SQL Server 佔用的空間 Transaction log 和Database file -- select database USE Production; -- Change the recovery mode to SIMPLE, to clear the …
Today I need to do a query to get all the record which has 3 decimal places on one of the field and process them by using different method. I am wondering if there any default TSQL …