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,513 reads
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,629 reads
2008-07-29 (first published: 2008-06-08)
1,276 reads
Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...
By Brian Kelley
In parallel with the presentation I gave at the PASS Data Community Summit on...
SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When...
Hi all, Has anyone encountered an issue whereby using a distributed availability group...
hi, i have seen in my server sometimes some SPIDs get stuck. so we...
Recently I was asked to investigate the update statistics process on a particular database....
When does this code work and when does it fail?
DECLARE @BaseDate DATETIME = '1900-01-01'; SELECT DATEADD(SECOND, 2147483648, @BaseDate) AS [MaxIntSecondsAdded];See possible answers