Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Category archives for: Tips & Tricks

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?

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

SQL Server – Determining Index Usage

SQL Server – Determining Index Usage

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.

SQL Server – Values of Newly Added Columns

SQL Server – Values of Newly Added Columns

What happens if we add a column to a table? What value does this column get?

Log in / Advanced NewsPaper by Gabfire Themes