Skip to content
/ SQLServerHelpScripts Public

A collection of various adhoc SQL Server scripts which can be used to monitor, administer, copy, tune etc varous SQL Server database, tables, indexes or instances

21 stars 12 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

MrFoxSQL/SQLServerHelpScripts

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
KillDBConnections.sql
KillDBConnections.sql
 
 
ListDBFileGrowthHistoryFromDefaultTrace.sql
ListDBFileGrowthHistoryFromDefaultTrace.sql
 
 
ListDBFileSettingsAndGrowth(2012+).sql
ListDBFileSettingsAndGrowth(2012+).sql
 
 
ListDBHowMuchDataHasChangedSinceFullBackup.sql
ListDBHowMuchDataHasChangedSinceFullBackup.sql
 
 
ListDBNotAccessed.sql
ListDBNotAccessed.sql
 
 
ListDBOnSameDriveLetter.sql
ListDBOnSameDriveLetter.sql
 
 
ListIndexFrag.sql
ListIndexFrag.sql
 
 
ListIndexesAll.sql
ListIndexesAll.sql
 
 
ListIndexesNotUsed.sql
ListIndexesNotUsed.sql
 
 
ListIndexesUsed.sql
ListIndexesUsed.sql
 
 
ListLastDBBackups.sql
ListLastDBBackups.sql
 
 
ListLastDBRestores.sql
ListLastDBRestores.sql
 
 
ListLastTimeTableStatsUpdated.sql
ListLastTimeTableStatsUpdated.sql
 
 
ListSSRSReportsSchedules.sql
ListSSRSReportsSchedules.sql
 
 
ListSSRSReportsSchedulesAndHistory.sql
ListSSRSReportsSchedulesAndHistory.sql
 
 
ListTableCompressionSettings.sql
ListTableCompressionSettings.sql
 
 
ListTablePartitionCalculationFromColoumn.sql
ListTablePartitionCalculationFromColoumn.sql
 
 
ListTablePartitionSettings.sql
ListTablePartitionSettings.sql
 
 
ListTablesLastAccessed.sql
ListTablesLastAccessed.sql
 
 
ListTablesNotAccessed.sql
ListTablesNotAccessed.sql
 
 
ListTablesWithNoPrimaryKey.sql
ListTablesWithNoPrimaryKey.sql
 
 
README.md
README.md
 
 
SQLGen_AttachDatabases.sql
SQLGen_AttachDatabases.sql
 
 
SQLGen_AutoShrinkClose.sql
SQLGen_AutoShrinkClose.sql
 
 
SQLGen_Backup.sql
SQLGen_Backup.sql
 
 
SQLGen_ChangeDBOwner.sql
SQLGen_ChangeDBOwner.sql
 
 
SQLGen_DBCC_CHECKDB.sql
SQLGen_DBCC_CHECKDB.sql
 
 
SQLGen_DBCompatLevel.sql
SQLGen_DBCompatLevel.sql
 
 
SQLGen_DBIndexPhysicalStats.sql
SQLGen_DBIndexPhysicalStats.sql
 
 
SQLGen_DBRecoveryMode.sql
SQLGen_DBRecoveryMode.sql
 
 
SQLGen_DetachDatabases.sql
SQLGen_DetachDatabases.sql
 
 
SQLGen_DropAllIndexes.sql
SQLGen_DropAllIndexes.sql
 
 
SQLGen_ExtractAllDatabaseIndexScripts.sql
SQLGen_ExtractAllDatabaseIndexScripts.sql
 
 
SQLGen_ForeignKeys.sql
SQLGen_ForeignKeys.sql
 
 
SQLGen_Offline.sql
SQLGen_Offline.sql
 
 
SQLGen_ReindexAllIndexes.sql
SQLGen_ReindexAllIndexes.sql
 
 
SQLGen_ReindexFullText.sql
SQLGen_ReindexFullText.sql
 
 
SQLGen_RenameObjects.sql
SQLGen_RenameObjects.sql
 
 
SQLGen_RestoreDBFromBackupFile.sql
SQLGen_RestoreDBFromBackupFile.sql
 
 
SQLGen_SQLAgentJobsDisableEnable.sql
SQLGen_SQLAgentJobsDisableEnable.sql
 
 
SQLGen_SetDefaultSchema.sql
SQLGen_SetDefaultSchema.sql
 
 
SQLGen_Shrink_File.sql
SQLGen_Shrink_File.sql
 
 
SQLGen_SysMessages.sql
SQLGen_SysMessages.sql
 
 
SQLGen_TPD.sql
SQLGen_TPD.sql
 
 
SQLGen_TableAndIndexCompression.sql
SQLGen_TableAndIndexCompression.sql
 
 
SQLGen_TableIndexCompression.sql
SQLGen_TableIndexCompression.sql
 
 
SQLGen_UpdateStatistics.sql
SQLGen_UpdateStatistics.sql
 
 

Repository files navigation

About

A collection of various adhoc SQL Server scripts which can be used to monitor, administer, copy, tune etc varous SQL Server database, tables, indexes or instances

Resources

Readme
Activity

Stars

21 stars

Watchers

3 watching

Forks

12 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages