list of .sql files - ktaranov/sqlserver-kit GitHub Wiki
Here is an a-z list of scripts on the wiki
- Test
File | Path |
---|---|
AutoGuessingForeignKeyConstraints.sql | \Scripts\AutoGuessingForeignKeyConstraints.sql |
Backup_Restore_What's_My_Status.sql | \Scripts\Backup_Restore_What's_My_Status.sql |
BackupRestoreTrace.sql | \Extended_Events\BackupRestoreTrace.sql |
BaselineCollectorSolution.sql | \Solution\BaselineCollector\BaselineCollectorSolution.sql |
Blocked_Session.sql | \Scripts\Blocked_Session.sql |
BufferPoolExtension.sql | \Scripts\BufferPoolExtension.sql |
CommandExecute.sql | \Solution\Ola_Maintenance_Solution\CommandExecute.sql |
CommandLog.sql | \Solution\Ola_Maintenance_Solution\CommandLog.sql |
ConvertingSQLTracetoExtendedEvents.sql | \Extended_Events\ConvertingSQLTracetoExtendedEvents.sql |
Count character matches.sql | \Scripts\Count character matches.sql |
CPU_Utilization.sql | \Scripts\CPU_Utilization.sql |
CPU_Utilization_Graphical_form.sql | \Scripts\CPU_Utilization_Graphical_form.sql |
Current_Running_Queries.sql | \Scripts\Current_Running_Queries.sql |
Current_Running_Tasks_and_Server_Info.sql | \Scripts\Current_Running_Tasks_and_Server_Info.sql |
DarkQueries.sql | \Extended_Events\DarkQueries.sql |
Database_Mail_Configuration.sql | \Scripts\Database_Mail_Configuration.sql |
DatabaseBackup.sql | \Solution\Ola_Maintenance_Solution\DatabaseBackup.sql |
DatabaseIntegrityCheck.sql | \Solution\Ola_Maintenance_Solution\DatabaseIntegrityCheck.sql |
Date Calendar Cross-Reference Table.sql | \Scripts\Date Calendar Cross-Reference Table.sql |
Date_Format_Cheat_Sheet.sql | \Scripts\Date_Format_Cheat_Sheet.sql |
DBA_sp_jobhistory_row_limiter.sql | \Solution\SysJobHistory\DBA_sp_jobhistory_row_limiter.sql |
DBA_sysjobhistory_config_tbl.sql | \Solution\SysJobHistory\DBA_sysjobhistory_config_tbl.sql |
DBA_sysjobhistory_driver.sql | \Solution\SysJobHistory\DBA_sysjobhistory_driver.sql |
DBA_sysjobhistory_driver_Tests.sql | \Solution\SysJobHistory\DBA_sysjobhistory_driver_Tests.sql |
dbWarden.sql | \Solution\dbWarden\dbWarden.sql |
dbWarden_UNINSTALL.sql | \Solution\dbWarden\dbWarden_UNINSTALL.sql |
Deadlocks.sql | \Extended_Events\Deadlocks.sql |
Decrypt T-SQL module.sql | \Scripts\Decrypt T-SQL module.sql |
DynamicallyGenerateDMAStatement.sql | \Scripts\DynamicallyGenerateDMAStatement.sql |
Enable Microsoft.ACE.OLEDB.12.0.sql | \Scripts\Enable Microsoft.ACE.OLEDB.12.0.sql |
Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql | \Scripts\Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql |
Finding_Blocking_Queries.sql | \Scripts\Finding_Blocking_Queries.sql |
FindingSpecificColumns.sql | \Scripts\FindingSpecificColumns.sql |
FindTablesWithSimilarTableStructure.sql | \Scripts\FindTablesWithSimilarTableStructure.sql |
fn_recurringDates.sql | \User_Defined_Function\fn_recurringDates.sql |
FN_SPLIT.sql | \User_Defined_Function\FN_SPLIT.sql |
fnWordDifference.sql | \User_Defined_Function\fnWordDifference.sql |
Foreign_Key_batch_rename.sql | \Scripts\Foreign_Key_batch_rename.sql |
Generate_Restore_Script_From_Backup_Folder.sql | \Scripts\Generate_Restore_Script_From_Backup_Folder.sql |
Get_Statistics_Details.sql | \Scripts\Get_Statistics_Details.sql |
Get_Table_Hierarchy.sql | \Scripts\Get_Table_Hierarchy.sql |
GetResourceNameFromBlockedProcessReport.sql | \Scripts\GetResourceNameFromBlockedProcessReport.sql |
GoogleJobTimeline.sql | \Scripts\GoogleJobTimeline.sql |
How_old_your_backups.sql | \Scripts\How_old_your_backups.sql |
How_to_Find_Queries_Using_an_Index.sql | \Scripts\How_to_Find_Queries_Using_an_Index.sql |
Identify_All_Logins_With_No_Associated_Default_Database_User.sql | \Scripts\Identify_All_Logins_With_No_Associated_Default_Database_User.sql |
Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql | \Scripts\Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql |
IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql | \Scripts\IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql |
Identity_gap_sql_server_2012.sql | \Errors\Identity_gap_sql_server_2012.sql |
Index Breakdown.sql | \Scripts\Index Breakdown.sql |
Indexes_Script_Out.sql | \Scripts\Indexes_Script_Out.sql |
IndexOptimize.sql | \Solution\Ola_Maintenance_Solution\IndexOptimize.sql |
InstallRegex.sql | \CLR\Regex\Fill_Factor\InstallRegex.sql |
installRegexAssembly.sql | \CLR\Regex\Fill_Factor\installRegexAssembly.sql |
installRegexSample.sql | \CLR\Regex\Fill_Factor\installRegexSample.sql |
InvestigateWaits.sql | \Extended_Events\InvestigateWaits.sql |
LatchStats.sql | \Scripts\LatchStats.sql |
Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql | \Scripts\Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql |
LoginFailure.sql | \Extended_Events\LoginFailure.sql |
loop.sql | \SSMS\SSMS_Snippets\loop.sql |
MaintenanceSolution.sql | \Solution\Ola_Maintenance_Solution\MaintenanceSolution.sql |
MAXDOP_recommendation.sql | \Scripts\MAXDOP_recommendation.sql |
MaxServerMemoryCalculator.sql | \Scripts\MaxServerMemoryCalculator.sql |
Monitor_Deadlocks_with_Extended_Events.sql | \Scripts\Monitor_Deadlocks_with_Extended_Events.sql |
New_Default_Database_Assignment_For_Any_Login _Missing_Their_Default_Database.sql |
\Scripts\New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql |
PowerSavingCheck.sql | \Scripts\PowerSavingCheck.sql |
Procedure_dynamic_create.sql | \SSMS\SSMS_Snippets\Procedure_dynamic_create.sql |
QueryActiveDirectory.sql | \Scripts\QueryActiveDirectory.sql |
Recompile_Histogram.sql | \Extended_Events\Recompile_Histogram.sql |
RemoveNonAlphaCharacters.sql | \User_Defined_Function\RemoveNonAlphaCharacters.sql |
RenameDefaultConstraints.sql | \Scripts\RenameDefaultConstraints.sql |
Restore_script_for_Ola_Hallengren_backup.sql | \Scripts\Restore_script_for_Ola_Hallengren_backup.sql |
Ring_Bufer_Analyze.sql | \Scripts\Ring_Bufer_Analyze.sql |
Search_Script.sql | \Scripts\Search_Script.sql |
seeddata.sql | \Solution\SysJobHistory\seeddata.sql |
Show all permissions in a database.sql | \Scripts\Show all permissions in a database.sql |
ShredDeadlockGraph.sql | \Scripts\ShredDeadlockGraph.sql |
sp_AllocationMetadata.sql | \Stored_Procedure\sp_AllocationMetadata.sql |
sp_Blocked_Process_Report_Viewer.sql | \Stored_Procedure\sp_Blocked_Process_Report_Viewer.sql |
sp_capture_login_auth.sql | \Stored_Procedure\sp_capture_login_auth.sql |
sp_ctrl3.sql | \Stored_Procedure\sp_ctrl3.sql |
sp_DBA_job_notification.sql | \Stored_Procedure\sp_DBA_job_notification.sql |
sp_DBPermissions.sql | \Stored_Procedure\sp_DBPermissions.sql |
sp_Defrag_Indexes.sql | \Stored_Procedure\sp_Defrag_Indexes.sql |
sp_Example_RegisterAssembly_PDFCLR.sql | \Stored_Procedure\sp_Example_RegisterAssembly_PDFCLR.sql |
sp_generate_merge.sql | \Stored_Procedure\sp_generate_merge.sql |
sp_helpExpandView.sql | \Stored_Procedure\sp_helpExpandView.sql |
sp_IndexAnalysis-v11.sql | \Stored_Procedure\sp_IndexAnalysis-v11.sql |
sp_RestoreGene.sql | \Stored_Procedure\sp_RestoreGene.sql |
sp_sizing.sql | \Stored_Procedure\sp_sizing.sql |
sp_SQLskills_ExposeColsInIndexLevels.sql | \Stored_Procedure\sp_SQLskills_ExposeColsInIndexLevels.sql |
sp_SQLskills_helpindex.sql | \Stored_Procedure\sp_SQLskills_helpindex.sql |
sp_sqltrace.sql | \Stored_Procedure\sp_sqltrace.sql |
sp_SrvPermissions.sql | \Stored_Procedure\sp_SrvPermissions.sql |
sp_WhatsupQueryStore.sql | \Stored_Procedure\sp_WhatsupQueryStore.sql |
Space used by object.sql | \Scripts\Space used by object.sql |
SpaceusedByTable.sql | \Scripts\SpaceusedByTable.sql |
SplitFileGroup.sql | \Scripts\SplitFileGroup.sql |
SplitterB_CLR.sql | \CLR\SplitterB_CLR.sql |
SQL Server 2005 Diagnostic Information Queries.sql | \Scripts\SQL Server 2005 Diagnostic Information Queries.sql |
SQL Server 2008 Diagnostic Information Queries.sql | \Scripts\SQL Server 2008 Diagnostic Information Queries.sql |
SQL Server 2008 R2 Diagnostic Information Queries.sql | \Scripts\SQL Server 2008 R2 Diagnostic Information Queries.sql |
SQL Server 2012 Diagnostic Information Queries.sql | \Scripts\SQL Server 2012 Diagnostic Information Queries.sql |
SQL Server 2014 Diagnostic Information Queries.sql | \Scripts\SQL Server 2014 Diagnostic Information Queries.sql |
SQL Server 2016 Diagnostic Information Queries.sql | \Scripts\SQL Server 2016 Diagnostic Information Queries.sql |
SQL Server 2017 Diagnostic Information Queries.sql | \Scripts\SQL Server 2017 Diagnostic Information Queries.sql |
SQL_Server_Fixed_Role_Permissions.sql | \Scripts\SQL_Server_Fixed_Role_Permissions.sql |
sqlg_ParseDiskskpXml.sql | \Stored_Procedure\sqlg_ParseDiskskpXml.sql |
system_health.sql | \Extended_Events\system_health.sql |
Table Count alternative.sql | \Scripts\Table Count alternative.sql |
Table_and_Index_storage_size.sql | \Scripts\Table_and_Index_storage_size.sql |
Table_upload_order.sql | \Scripts\Table_upload_order.sql |
Tempdb_Contention.sql | \Scripts\Tempdb_Contention.sql |
tempdb_Information.sql | \Scripts\tempdb_Information.sql |
TrackPageSplits.sql | \Extended_Events\TrackPageSplits.sql |
Truncate log file.sql | \Scripts\Truncate log file.sql |
TuneYourIndexingStrategyWithDMVs.sql | \Scripts\TuneYourIndexingStrategyWithDMVs.sql |
udf_2DateDiff.sql | \User_Defined_Function\udf_2DateDiff.sql |
udf_AlphaNumericOnly.sql | \User_Defined_Function\udf_AlphaNumericOnly.sql |
udf_AlphaOnly.sql | \User_Defined_Function\udf_AlphaOnly.sql |
udf_CalculateDistanceBetween2Coordinates.sql | \User_Defined_Function\udf_CalculateDistanceBetween2Coordinates.sql |
udf_CalcWorkingHours.sql | \User_Defined_Function\udf_CalcWorkingHours.sql |
udf_ConvertRangesInIntegerList.sql | \User_Defined_Function\udf_ConvertRangesInIntegerList.sql |
udf_DamLev.sql | \User_Defined_Function\udf_DamLev.sql |
udf_DateFormattedByMask.sql | \User_Defined_Function\udf_DateFormattedByMask.sql |
udf_DigitsOnlyEE.sql | \User_Defined_Function\udf_DigitsOnlyEE.sql |
udf_FindPosition.sql | \User_Defined_Function\udf_FindPosition.sql |
udf_ForeignKeyScript.sql | \User_Defined_Function\udf_ForeignKeyScript.sql |
udf_FuzzySearchOf.sql | \User_Defined_Function\udf_FuzzySearchOf.sql |
udf_GetNumsAB.sql | \User_Defined_Function\udf_GetNumsAB.sql |
udf_Haversine.sql | \User_Defined_Function\udf_Haversine.sql |
udf_INSTR.sql | \User_Defined_Function\udf_INSTR.sql |
udf_IntegerListFromRangesFunction.sql | \User_Defined_Function\udf_IntegerListFromRangesFunction.sql |
udf_Is16digitValidCard.sql | \User_Defined_Function\udf_Is16digitValidCard.sql |
udf_IsValidCard.sql | \User_Defined_Function\udf_IsValidCard.sql |
udf_parseJSON.sql | \User_Defined_Function\udf_parseJSON.sql |
udf_PatExclude8K.sql | \User_Defined_Function\udf_PatExclude8K.sql |
udf_PatReplace8K.sql | \User_Defined_Function\udf_PatReplace8K.sql |
udf_PatternSplitLoop.sql | \User_Defined_Function\udf_PatternSplitLoop.sql |
udf_RenderXMLToString.sql | \User_Defined_Function\udf_RenderXMLToString.sql |
udf_RTF2Text.sql | \User_Defined_Function\udf_RTF2Text.sql |
udf_SecondConvertRangesInIntegerList.sql | \User_Defined_Function\udf_SecondConvertRangesInIntegerList.sql |
udf_SplitStringByDelimiter.sql | \User_Defined_Function\udf_SplitStringByDelimiter.sql |
udf_StringComparisonsLevenshteinFull-matrix.sql | \User_Defined_Function\udf_StringComparisonsLevenshteinFull-matrix.sql |
udf_StringComparisonsLevenshteinString-based.sql | \User_Defined_Function\udf_StringComparisonsLevenshteinString-based.sql |
udf_StringComparisonsLongestCommonSubsequence.sql | \User_Defined_Function\udf_StringComparisonsLongestCommonSubsequence.sql |
udf_StringComparisonsMetaphoneAlgorithm.sql | \User_Defined_Function\udf_StringComparisonsMetaphoneAlgorithm.sql |
udf_strtok.sql | \User_Defined_Function\udf_strtok.sql |
udf_Tally.sql | \User_Defined_Function\udf_Tally.sql |
udp_IntegerListfromRanges.sql | \Stored_Procedure\udp_IntegerListfromRanges.sql |
ufn_HolidayList.sql | \User_Defined_Function\ufn_HolidayList.sql |
UnPivot_Output_Restore_Headeronly.sql | \Scripts\UnPivot_Output_Restore_Headeronly.sql |
usp_bcpTableUnload.sql | \Stored_Procedure\usp_bcpTableUnload.sql |
usp_bcpTableUnloadBatchMode.sql | \Stored_Procedure\usp_bcpTableUnloadBatchMode.sql |
usp_bcpUnloadSelect.sql | \Stored_Procedure\usp_bcpUnloadSelect.sql |
usp_BulkUpload.sql | \Stored_Procedure\usp_BulkUpload.sql |
usp_checkAllDatabases.sql | \Stored_Procedure\usp_checkAllDatabases.sql |
usp_CopyLogins.sql | \Stored_Procedure\usp_CopyLogins.sql |
usp_CreatePlantUMLCode.sql | \Stored_Procedure\usp_CreatePlantUMLCode.sql |
usp_DBA_Rename_Database.sql | \Stored_Procedure\usp_DBA_Rename_Database.sql |
usp_EnableAndAddFileStreamForDatabase.sql | \Stored_Procedure\usp_EnableAndAddFileStreamForDatabase.sql |
usp_FindDbObjects.sql | \Stored_Procedure\usp_FindDbObjects.sql |
usp_Generate_Merge.sql | \Stored_Procedure\usp_Generate_Merge.sql |
usp_GetPackageDetails.sql | \Stored_Procedure\usp_GetPackageDetails.sql |
usp_GetUntrustedForeignKeys.sql | \Stored_Procedure\usp_GetUntrustedForeignKeys.sql |
usp_LoadTableBlobs.sql | \Stored_Procedure\usp_LoadTableBlobs.sql |
usp_LogError.sql | \Stored_Procedure\usp_LogError.sql |
usp_MonitorIdentityColumn.sql | \Stored_Procedure\usp_MonitorIdentityColumn.sql |
usp_Object_Search.sql | \Stored_Procedure\usp_Object_Search.sql |
usp_PrintDebug.sql | \Stored_Procedure\usp_PrintDebug.sql |
usp_PrintError.sql | \Stored_Procedure\usp_PrintError.sql |
usp_PrintString.sql | \Stored_Procedure\usp_PrintString.sql |
usp_RandomWait.sql | \Stored_Procedure\usp_RandomWait.sql |
usp_RunCheckAllUntrustedForeignKeys.sql | \Stored_Procedure\usp_RunCheckAllUntrustedForeignKeys.sql |
usp_SearchOnAllDB.sql | \Stored_Procedure\usp_SearchOnAllDB.sql |
usp_SetFileGrowth.sql | \Stored_Procedure\usp_SetFileGrowth.sql |
usp_SQL_Server_System_Report.sql | \Stored_Procedure\usp_SQL_Server_System_Report.sql |
usp_SQLskillsAnalyzeLog.sql | \Stored_Procedure\usp_SQLskillsAnalyzeLog.sql |
usp_SSIS_ScriptEnvironment.sql | \Stored_Procedure\usp_SSIS_ScriptEnvironment.sql |
usp_String_Search.sql | \Stored_Procedure\usp_String_Search.sql |
usp_TableUnpivot.sql | \Stored_Procedure\usp_TableUnpivot.sql |
usp_UnusedInputParameters.sql | \Stored_Procedure\usp_UnusedInputParameters.sql |
usp_who5.sql | \Stored_Procedure\usp_who5.sql |
Visualizing_Agent_Jobs_in_SSMS.sql | \Scripts\Visualizing_Agent_Jobs_in_SSMS.sql |
Visualizing_VLF.sql | \Scripts\Visualizing_VLF.sql |
Wait_Statistics.sql | \Scripts\Wait_Statistics.sql |
What_Agent_Job_is_Running.sql | \Scripts\What_Agent_Job_is_Running.sql |
Which_databases_were_backed_up_and_when.sql | \Scripts\Which_databases_were_backed_up_and_when.sql |
Which_Filegroup_is_that_Partition_Using.sql | \Scripts\Which_Filegroup_is_that_Partition_Using.sql |
Which_Indexes_are_not_Used.sql | \Scripts\Which_Indexes_are_not_Used.sql |
WhiteListIPTable.sql | \Scripts\WhiteListIPTable.sql |
Who_dropped_database.sql | \Scripts\Who_dropped_database.sql |
Windows logins not in AD.sql | \Scripts\Windows logins not in AD.sql |
category:sql scripts return to: home