2025-05-19
556 reads
2025-05-19
556 reads
Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
2025-05-16
2,916 reads
2025-05-12
275 reads
2025-05-05
448 reads
2025-04-30
437 reads
2025-04-21
1,895 reads
I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?
2025-04-18
From time to time, I encounter blocking situations where I end up issuing a SQL KILL command against the blocking SPID. When I run sp_who2, I can see the killed SPID is in a ROLLBACK state. Is there any way I can get an idea of how long the rollback for the SPID will take?
2025-04-09
2025-04-04
1,255 reads
Over the last several years, Microsoft has been putting less and less effort into Cumulative Update documentation. We used to get full-blown knowledge base articles about fixes, but these days, we get a collection of footnotes with deceiving hyperlinks that look like they’re going to lead to more information – but they simply lead back to themselves.
2025-03-31
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
QLola BRI bermasalah? Segera hubungi WhatsApp 08136035412 untuk mendapatkan solusi praktis dan panduan lengkap...
Butuh bantuan QLola BRI? Langsung saja chat WhatsApp 08136035412. Tim siap membantu dengan pelayanan...
Layanan bantuan QLola BRI via WhatsApp 08136035412 siap memberikan solusi yang aman, cepat, dan...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers