Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on Sep 8, 2025

• Create DEADLOCK - Read deadlocks from error logs.sql

  samyan19

  authored
  becde71

  Copy full SHA for becde71

Commits on Aug 27, 2025

• Update SECURITY - Script out COMPLETE user permissions to TSQL.sql

  samyan19

  authored
  f80eac0

  Copy full SHA for f80eac0

Commits on Aug 21, 2025

• Create SAM - Free space in database files.sql

  samyan19

  authored
  475a869

  Copy full SHA for 475a869

Commits on Jan 17, 2025

• Update SECURITY - Find membership of AD groups -xp_logininfo.sql

  samyan19

  authored
  c4f70c4

  Copy full SHA for c4f70c4

• Rename SECURITY - xp_logininfo.sql to SECURITY - Find membership of AD groups -xp_logininfo.sql

  samyan19

  authored
  cac362f

  Copy full SHA for cac362f

Commits on Nov 20, 2024

• Rename JOBS - Disable jobs on Failover in AG using catagories to JOBS - Disable jobs on Failover in AG using catagories.sql

  samyan19

  authored
  67e01e2

  Copy full SHA for 67e01e2

• Create JOBS - Disable jobs on Failover in AG using catagories

  samyan19

  authored
  fd7dc16

  Copy full SHA for fd7dc16

Commits on Aug 16, 2024

• Update DISK - CrystalDiskMark Reference.sql

  samyan19

  authored
  871924c

  Copy full SHA for 871924c

Commits on Feb 27, 2024

• Create CONNECTIONS - Find details of active connections.sql

  samyan19

  authored
  7559838

  Copy full SHA for 7559838

Commits on Sep 22, 2023

• Create Automatic Seeding Check.sql

  samyan19

  authored
  22153ed

  Copy full SHA for 22153ed

Commits on Aug 18, 2023

• Create Check oldest record is SSISDB.sql

  samyan19

  authored
  ad817de

  Copy full SHA for ad817de

Commits on Aug 7, 2021

• Create PLANCACHE - List Plans in Cache with Parameterized Plans.sql

  samyan19

  authored
  1dcc1db

  Copy full SHA for 1dcc1db

• Create WAITS - Collect Stats Reset Method.sql

  samyan19

  authored
  6a05b04

  Copy full SHA for 6a05b04

Commits on Aug 6, 2021

• Create PLANCACHE - 8 Ways to Clear Plan Cache.sql

  samyan19

  authored
  0cfb218

  Copy full SHA for 0cfb218

• Create PLANCACHE - CLear Single Use Plans.sql

  samyan19

  authored
  8a8b51e

  Copy full SHA for 8a8b51e

Commits on Jul 30, 2021

• Create AZURE - Check Disk Configuration.sql

  samyan19

  authored
  a6d86ba

  Copy full SHA for a6d86ba

Commits on Jul 21, 2021

• Create PLAN CACHE - sp_cachobjects.sql

  samyan19

  authored
  0d19195

  Copy full SHA for 0d19195

Commits on Jul 14, 2021

• Create Waits - Collect waits for 24 hours - Paul Randal.sql

  samyan19

  authored
  a1381ad

  Copy full SHA for a1381ad

Commits on Jun 23, 2021

• Update WAITS - Collect Waits Over Time.sql

  samyan19

  authored
  b9372a4

  Copy full SHA for b9372a4

• Create WAITS - Collect Waits Over Time.sql

  samyan19

  authored
  4f20c34

  Copy full SHA for 4f20c34

Commits on Apr 1, 2021

• Create INDEX - Drop Constraints.sql

  samyan19

  authored
  5f71437

  Copy full SHA for 5f71437

• Create INDEX - Drop Non CLustered Indexes.sql

  samyan19

  authored
  632ac12

  Copy full SHA for 632ac12

Commits on Mar 31, 2021

• Update INDEX - Drop all INdexes and Constraints.sql

  samyan19

  authored
  a44b044

  Copy full SHA for a44b044

Commits on Mar 30, 2021

• Create INDEX - Drop all INdexes and Constraints.sql

  samyan19

  authored
  572280e

  Copy full SHA for 572280e

Commits on Oct 7, 2020

• Add files via upload

  samyan19

  authored
  4e12be3

  Copy full SHA for 4e12be3

• Create Azure SQL DB Diagnostic Queries.sql

  samyan19

  authored
  ea41f5b

  Copy full SHA for ea41f5b

Commits on Aug 7, 2020

• Create SAM - Count number of files in error log location.sql

  samyan19

  authored
  e69bd64

  Copy full SHA for e69bd64

Commits on Jul 29, 2020

• Create XE- Extended Events in Azure SQL.sql

  samyan19

  authored
  38a1cd2

  Copy full SHA for 38a1cd2

Commits on Jul 17, 2020

• Add files via upload

  samyan19

  authored
  0a720cb

  Copy full SHA for 0a720cb

Commits on Aug 2, 2019

• Create create table columstore index and populate example.sql

  samyan19

  authored
  9ae12a1

  Copy full SHA for 9ae12a1

Commits on Feb 1, 2019

• Create SECURITY - List Permissions Assigned to a Role.sql

  samyan19

  authored
  6f2f139

  Copy full SHA for 6f2f139

Commits on Oct 12, 2018

• Create TSQL - Search for text in COLUMN.sql

  samyan19

  authored
  fa16813

  Copy full SHA for fa16813

Commits on Oct 1, 2018

• Update BACKUP - Backup completion estimates.sql

  samyan19

  authored
  db26762

  Copy full SHA for db26762

Commits on Sep 27, 2018

• Update DATABASE-Shrink All Log Files.sql

  samyan19

  authored
  ba566b2

  Copy full SHA for ba566b2

Commits on Sep 14, 2018

• Update DATABASE-Shrink All Log Files.sql

  samyan19

  authored
  dcf8095

  Copy full SHA for dcf8095

Pagination

Previous

Next