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.
What happens if we add a column to a table? What value does this column get?
February 7, 2010 | Posted in
SQL Server,
Tips & Tricks |
Read More »