Category: SQL Server

Speeding up database access

This is a very thorough article on ways to speed up a SQL database by Matt Perdeck Speeding up database access – Part 1: Missing indexes

Posted in SQL Server Tagged with: ,

Script to restore SQL Server database

A lot of people know how to restore an SQL Server database using the SQL Server Management Studio. Sometime it will not work if the database is in use. You have to close all active connections or even to take

Posted in CodeProject, Howto, Software Development, SQL Server Tagged with: ,

TRUNCATE Log File in SQL Server 2008

USE [TestDb] GO ALTER DATABASE [TestDb] SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(TestDbLog, 1) ALTER DATABASE [TestDb] SET RECOVERY FULL WITH NO_WAIT GO

Posted in Howto, SQL Server Tagged with: ,