Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
There are two main ways to delete all records from a table – DELETE and TRUNCATE commands, but if we do, can we rollback the operation?
In this article we will demonstrate how to retrieve the startup time of SQL Server
Indexes have large effect on each database. They can improve queries performance dramatically, but too many of them can cause performance degradation and overhead when changing data. This tip contains a script that will help you to find useful information about index usage in your database.
Log shipping is the process of automating transaction log copy and apply in order to maintain identical database copy for high-availability or disaster recovery proposes.
Learn how to audit sql server’s login, its simple and its quick.
SQL Server 2005 provides a set of high availability methods that the users can use to achieve fault tolerance and to prevent server outages and data loss. The selection of the high availability method depends on various factors. Some DBAs need the servers to be available 24/7, while others can afford an outage of a couple of hours. Cost also plays a role in the selection. For example, Clustering is an expensive high availability method when compared to Database Mirroring, but it allows the user to failover immediately.