Tags: index

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »

New Version of SQL Server Maintenance Solution by Ola Hallengren Now Available

Ola Hallengren and his ongoing work of his SQL Server Maintenance Solution - SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.The solution is based on stored procedures, functions, the sqlcmd utility, and SQL Server Agent jobs.… more »

Backup, Integrity Check and Index Optimization - CTP

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization  (Best Free Tool - Gold)scripts, a solution based on stored procedures, functions, sqlcmd and SQL Server Agent jobs. He makes some inte… more »

Backup, Integrity Check and Index Optimization

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-) He made some important updates to his maintenance scripts: Support for selection of schemas, objects and… more »

Backup, Integrity Check and Index Optimization

Ola Hallengren and his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - makes me happy :-) He made some updates to the maintenance scripts: Changed behaviour in the job that deletes old output… more »

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

I'm sure, that's exactly what Albert Einstein meant in his quote:"Try not to become a man of success but rather to become a man of value", Ola Hallengren becomes a man of value - with his ongoing work of his SQL Server 2005 and 2008 - Backup, Integrity… more »

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Ola Hallengren, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts: Support for printing of commands without executing them. Set the new parameter… more »

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Ola Hallengren Ola, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts: Support for Xml indexes Support for Spatial indexes Support for indexed views… more »

Dynamische Verwaltungssichten und -funktionen für Indizes - I

SQL Server 2005 teilt die dynamischen Verwaltungssichten und -funktionen nach der Modul-Komponente - zu der sie in Beziehung stehen - in zwölf Kategorien auf. Das diesem Artikel zugrunde liegende Objekt sys.dm_db_index_operational_stats gehört zur… mehr »