SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Zora's SQL Tips

Hi! I am Zora Stalin, an IT geek and a passionate learner of technology. Besides my job as an Information Technology Analyst, I love searching and sharing new things that excite me help for others.

Archives: July 2016

Reasons For Backup Failure In SQL Server and their Prevention


The entire idea behind a backup, is to protect any organization from the data loss and corruption. However, the question arises what happen if user will loose the backup. Many times we still hear about businesses breaking down due to data loss. In this article we will discuss the… Read more

0 comments, 3,506 reads

Posted in Zora's SQL Tips on 30 July 2016

Know How to Handle Deadlock in SQL Server

Introduction To Deadlock

Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the resource as the other processes are preventing it from getting the resource. It is a very common issue in SQL… Read more

3 comments, 6,790 reads

Posted in Zora's SQL Tips on 4 July 2016