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

home

Clone this wiki locally