Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Archive for: July, 2010

Rolling back TRUNCATE statements in SQL Server

Rolling back TRUNCATE statements in SQL Server

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?

July 28, 2010 | Posted in Administration, Main-Administration, SQL Server - Latest Articles, Tips & Tricks | Read More »

Determine query for Linux process

Determine query for Linux process

In this article we will demonstrate how to retrieve the SQL statement of the most CPU consuming process in Linux/Unix

July 17, 2010 | Posted in Oracle, Oracle - Latest Articles, Tips & Tricks | Read More »

SQL Server – How to determine instance uptime

SQL Server – How to determine instance uptime

In this article we will demonstrate how to retrieve the startup time of SQL Server

July 9, 2010 | Posted in Administration, SQL Server, SQL Server - Latest Articles, Tips & Tricks | Read More »
Log in / Advanced NewsPaper by Gabfire Themes