default trace in SQL Server

https://www.red-gate.com/simple-talk/sql/performance/the-default-trace-in-sql-server-the-power-of-performance-and-security-auditing/ –enabling default trace sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘default trace enabled’, 1; GO RECONFIGURE; GO –querying default trace SELECT * FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150), ( SELECT TOP 1 f.[value] FROM sys.fn_trace_getinfo(NULL) f WHERE f.property = 2 )), DEFAULT) T JOIN sys.trace_events TE…

dbcc checkdb

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/10/20/consistency-checking-options-for-a-vldb.aspx DBCC CHECKDB includes: DBCC CHECKALLOC DBCC CHECKCATALOG DBCC CHECKTABLE http://sqlmag.com/blog/unkillable-dbcc-checkdb DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS   http://www.bpsoftware.com/Blog/post/2008/11/25/SQL-DBCC-CHECKTABLE-on-multiple-tables.aspx — set options SET NOCOUNT ON; SET ANSI_PADDING ON; SET ANSI_NULLS ON; SET QUOTED_IDENTIFIER ON; DECLARE @tablenames TABLE (TableName VARCHAR(255)); — populate table with tablenames INSERT INTO…