Mine are all in snippets.

;WITH rowCnts

AS (

-- Shows all user tables and row counts for the current database

-- Remove is_ms_shipped = 0 check to include system objects

-- i.index_id < 2 indicates clustered index (1) or hash table (0)

SELECT o.name

,

SCHEMA_NAME(o.schema_id) [schema] ,

ddps.row_count

FROM sys.indexes AS i

INNER JOIN sys.objects AS o ON i.object_id = o.object_id

INNER JOIN sys.dm_db_partition_stats AS ddps ON i.object_id = ddps.object_id

AND i.index_id = ddps.index_id

WHERE i.index_id < 2

AND o.is_ms_shipped = 0

)

SELECT [schema] ,

,[row_count]

FROM rowCnts

/*

WHERE

IN ( 'InvoiceLineItem',

'InvoicePaymentLineItem',

'InvoiceRefundLineItem' )

--*/

ORDER BY [schema],

DECLARE @search SYSNAME = 'codeset'

SELECT s.name, t.name, c.name

FROM sys.tables t

INNER JOIN sys.columns c ON c.object_id = t.object_id

INNER JOIN sys.schemas s ON s.schema_id = t.schema_id

WHERE t.name LIKE '%' + @search + '%'

OR c.name LIKE '%' + @search + '%'

ORDER BY t.name, c.name

DECLARE @search NVARCHAR(4000) = 'DPH'

select s.name [Job Name]

, js.step_name [Step Name]

, js.command

FROM msdb.dbo.sysjobs s

INNER JOIN msdb.dbo.sysjobsteps js ON js.job_id = s.job_id

WHERE s.name like '%' + @search + '%'

OR js.step_name like '%' + @search + '%'

OR js.command like '%' + @search + '%'

SELECT UseCounts, Cacheobjtype, Objtype, TEXT, query_plan

FROM sys.dm_exec_cached_plans cp

CROSS APPLY sys.dm_exec_sql_text(plan_handle) sqlT

CROSS APPLY sys.dm_exec_query_plan(plan_handle) qp

INNER JOIN sys.objects o ON sqlT.objectid = o.object_id

INNER JOIN sys.schemas s ON s.schema_id = o.schema_id

WHERE o.name = 'object_name'

AND s.name = 'schema_name';