Point-in-time restore and knowing where to stop

In some disaster recovery scenarios, a database needs to be restored to a point in time before a particular operation has occurred, e.g. before a user mistakenly dropped a table, ran a DELETE or UPDATE with no WHERE clause, etc. If the database is in the full recovery mode and the log backup chain is…

1

Adding the IDENTITY property to a column of an existing table

Until SQL Server 2005, it was not possible to alter a column in an existing table to add the IDENTITY property. To achieve that, it was necessary to create a new table with an IDENTITY column, and move the data into that table. For large tables, this could be problematic. With the introduction of table…

4

Tempdb configuration check script

There is a number of well known best practices for configuring the tempdb database on SQL Server. Specifically: Multiple data files are used (some sources recommend 1 data file per CPU core, while others recommend anywhere from 1/4 to 1 file per CPU core) All data files have equal size All data files have equal…

0