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/

SQL Server Reporting Services Advanced Charting

SQL Server Reporting Services Advanced Charting

SQL Server Reporting Services Advanced Charting

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;