Before to start to change everything, you must have a baseline that it established in normal load operation for comparisons. 1 2SELECT TOP 20 3 qs.sql_handle 4, DB_NAME(CAST(pa.value as INT)) as DatabaseName 5, qs.execution_count 6, qs.total_worker_time AS Total_CPU 7, total_CPU_inSeconds = qs.total_worker_time/1000000...
This article is nice ( we have a little bug ) , and the SQL script is not execute-safe (if you run twice, you have errors ). It is for a specific database, when you need to save all SQL Server, you must run for each database. 1 2PRINT '-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --' 3PRINT '-- SQL Security...
– Since SQL Server 2005 Management Studio lacks the Object Search feature, here is the simple query to find any column in a database 1 2Select O.name objectName, C.name ColumnName 3from sys.columns C inner join sys.objects O 4ON C.object_id=O.object_id 5where C.name like ‘%ColumntoFind%’order by...