SQL Server Backup, Integrity Check, and Index and Statistics Maintenance Rebuilding Indexes using the SSMS Database Maintenance Wizard Rebuild or Reorganize: SQL Server Index Maintenance SQL Server Maintenance Plan Best Practices Index Fragmentation Recommended SQL Server Maintenance Plan
Tag Archives: sql server
Search in stored procedures
SELECT OBJECT_NAME(id) FROM syscomments WHERE [text] LIKE ‘%foobar%’ AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1 GROUP BY OBJECT_NAME(id)