Why SHRINKFILE is a very bad thing, and what to do about it.
This article talks about why SHRINKFILE is a very bad thing, and what to do about it if you must shrink a database file.
2011-12-16 (first published: 2010-11-09)
56,240 reads
Simon Facer
- Interests: My kids, building furniture, DIY, garden ponds, SQL Server and PDW
2008-06-19
9,625 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Surya Kencana Telpon. 08388331767
WhatsApp 08388331767 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah,...
BCA KCP By Pass Ngurah RaiTelepon 083110611866
WhatsApp 083110611866Kompleks Pertokoan Ngurah Rai Jl. Bypass Ngurah Rai No.99 Blok A & B,...
BCA KCU WAHID HASYIM Telpon/WA:08218168291
BCA KCU WAHID HASYIM Telpon/WA:08218168291.Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers