2018-05-01
844 reads
2018-05-01
844 reads
2018-04-23
6,500 reads
2018-01-05
941 reads
DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.
2019-05-03 (first published: 2016-09-22)
890 reads
Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.
2016-07-29
4,889 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers