Monthly Archives: May 2009
Tips for Reducing SQL Server Locks
Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server ends the deadlock by automatically choosing one … Continue reading
Posted in Uncategorized
1 Comment
Membuat Backup Jobs di SQL Server 2005
Membuat Backup Jobs di SQL Server 2005 Ini bagi DBA yang membuat Maintenance Plan untuk membackup database. Di SQL 2005 Maintenance Plan, kalau membuat suatu plan backup database ada satu pilihan yang hilang dari WIZARD pada SQL 2000 yaitu menghapus … Continue reading