Tag Archives : sqlserver2005

How to disable indexes in SQL Server 2005 and 2008?

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server tutorials and tagged disable indexes sqlserver2005 sqlserver2008 on by .

Scenario proposal While looking through the new features in SQL Server 2005 and SQL Server 2008 we found a potentially interesting one called Disabling Indexes, which can be used to disable indexes on a table or a view. Can you give us a detailed explanation of how we go about using this new feature along […]

How to change the Sql Server backup folder?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged backup sqlserver2005 sqlserver2008 on by .

Scenario proposal When you install SQL Server the path for the installation is generally something such as the following: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL.  In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your […]