In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.
2013-03-08
6,789 reads
2013-02-08
2,083 reads
2012-12-11
2,039 reads
Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.
2012-11-20
8,748 reads
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,459 reads
In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?
2012-10-11
3,321 reads
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,933 reads
2012-09-21
2,330 reads
2012-09-14
3,275 reads
2012-09-11
2,986 reads
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
WhatsApp 083110611866Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten 42112
BCA KCP Summitmas Hub.0813•7887•595.Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, Senayan,...
Jl. Kartini Raya No.2B, Depok, Pancoran Mas, Depok City, West Java 16431
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers