https://dba.stackexchange.com/questions/182227/sql-server-clears-plan-cache-and-execution-stats-periodically
https://dba.stackexchange.com/questions/182227/sql-server-clears-plan-cache-and-execution-stats-periodically
SELECT
job.job_id,
notify_level_email,
name,
enabled,
description,
step_name,
command,
server,
database_name,
schedule_id
FROM
msdb.dbo.sysjobs job
INNER JOIN
msdb.dbo.sysjobsteps steps
ON job.job_id = steps.job_id
INNER JOIN msdb.dbo.sysjobschedules sch
on sch.job_id = job.job_id
WHERE
job.enabled = 1
https://stackoverflow.com/questions/3131160/create-procedure-permission-only
define a DML trigger to avoid it.
go to c:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log
remove the SQLAGENT.# files.
DECLARE @OldestDate datetime DECLARE @JobName varchar(256) -- Keep Last 10 days SET @OldestDate = GETDATE()-10 SET @JobName = 'daily_report_check' EXEC msdb.dbo.sp_purge_jobhistory @job_name=@JobName, @oldest_date=@OldestDate
DECLARE @OldestDate datetime
SET @OldestDate = GETDATE()-15
EXEC msdb.dbo.sp_purge_jobhistory @oldest_date=’2/15/2018′
How to make different log in audit choice?
https://docs.microsoft.com/en-us/sql/ssms/configure-login-auditing-sql-server-management-studio
HOw to view SQL server audit log in log?
https://msdn.microsoft.com/en-us/library/cc280728(v=sql.110).aspx
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/38339fd0-df84-455c-b13f-2de25f1b1008/repeat-row-and-column-headers-for-each-group?forum=sqlreportingservices
Dynamic group by columns
Build Dynamic Column Groups (and sub groups) in SSRS
privoting report group by region
http://www.sqlservergeeks.com/sql-server-how-to-handle-dynamic-column-report-in-ssrs/
How to determine the cache plan size in SQL server?
–SQL 2012+ Plan Cache Size
— How big is the plan cache SQL 2012
select name, sum(pages_kb) /1024.0 MBUsed
from sys.dm_os_memory_clerks
where name = ‘SQL PLans’
group by name;
–Pre-SQL 2012 Plan Cache Size
— How big is the plan cache pre SQL 2012
select name, SUM(single_pages_kb + multi_pages_kb)/1024.0 MBUsed
from sys.dm_os_memory_clerks
where name = ‘SQL PLans’
group by name;