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

return to: home

Clone this wiki locally