Files

.github
ADS
Articles
CLR
Errors
Extended_Events
Help
PowerShell
SSMS
Sample_Databases
Scripts
- Trace_Flag
- Adding_Trace_Flags_To_Startup_Parameters.sql
- AutoGuessingForeignKeyConstraints.sql
- Auto_Generate_Database_Documentation.sql
- Azure SQL Database Diagnostic Information Queries.sql
- Backup_Restore_What’s_My_Status.sql
- Bad_Query_Example_13_JOINS.sql
- Benchmark_TSQL.R
- Blocked_Session.sql
- Bufer_Cache_Info.sql
- BufferPoolExtension.sql
- Build_CREATE_TABLE_statement_using_dm_exec_describe_first_result_set.sql
- CPU_Utilization.sql
- CPU_Utilization_Graphical_form.sql
- Cached_Data_Per_Object_in_Memory.sql
- Change_NonDefault_Collation_for_all_tables.sql
- CheckSpectreMeltdownStatus.sql
- Check_Reserved_Words_For_Object_Names.sql
- Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql
- Checkpoint_XE.sql
- Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example.sql
- Compare_2_tables_by_column_names.sql
- Compare_Tables_With_Matching_Columns.sql
- Compress_Tables_And_Indexes.sql
- Configure_SQL_Agent_Alerts.sql
- Count character matches.sql
- Count_Database_Reads_and_Writes.sql
- Create_2_Million_Tables.sql
- Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql
- Current_Running_Queries.sql
- Current_Running_Tasks_and_Server_Info.sql
- DBCC_CHECKDB_Latest_date.sql
- Data_Dictionary_Information.sql
- Database_Mail_Configuration.sql
- Database_Mail_Problems.sql
- Databases_Report.sql
- Date_Calendar_Cross-Reference_Table.sql
- Date_Format_Cheat_Sheet.sql
- Decrypt T-SQL module.sql
- Delete_Login_And_All_Users.sql
- DetermineSpaceWithinSQLDatabaseFiles.sql
- Disable_Enable_All_Triggers_In_Database.sql
- Disabling_Jobs_Schedules.sql
- Drop_all_objects_in_schema.sql
- Dynamic_GRANT_Generation.sql
- DynamicallyGenerateDMAStatement.sql
- Enable Microsoft.ACE.OLEDB.12.0.sql
- Enabling_Jobs_Schedules.sql
- Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql
- Extract_Scale_Part_From_Decimal_Number.sql
- Failed_SQL_Server_Agent_Jobs_With_Restart_Command.sql
- Fast_alternative_to_sp_WhoIsActive.sql
- FindDBConnectionLeaks.sql
- FindLongRunningJobSteps.sql
- FindTablesWithSimilarTableStructure.sql
- Find_Foreign_Key_Chains_For_Tables.sql
- Find_Maximum_Float_Values.sql
- Find_Non_Sargable_Queries.sql
- Find_Not_Used_Legacy_Tables.sql
- Find_Object_Dependecy.sql
- Find_SQL_Server_Integer_Columns_to_Make_Skinnier.sql
- Find_Status_of_SQL_Server_Statistics.sql
- Find_Synonyms_for_nested_objects_in_the_different_databases.sql
- Find_Synonyms_for_nested_objects_in_the_same_database.sql
- Find_Weak_Passwords.sql
- Find_and_fix_that_troublesome_Windows_Power_setting.sql
- FindingImplicitColumnConversionsInPlanCache.sql
- FindingSpecificColumns.sql
- Finding_Blocking_Queries.sql
- Finding_Host_Names_for_Failed_login_attempts.sql
- Fix_The_Broken_Dependencies_On_All_Objects.sql
- Foreign_Key_batch_rename.sql
- Foreign_Keys_With_No_Index.sql
- GenerateTSQLTimeSlices.sql
- Generate_BIML_Script.sql
- Generate_Restore_Script_From_Backup_Folder.sql
- Generate_table_definition_to_match_query.sql
- GetResourceNameFromBlockedProcessReport.sql
- Get_Amazon_RDS_Instance_Size.sql
- Get_CPU_Usage_Per_Database.sql
- Get_Coulmn_Statistics_By_Name.sql
- Get_Create_or_Alter_Index_Progress.sql
- Get_Database_Size_With_Graph.sql
- Get_Identity_Column_Information.sql
- Get_Latest_Success_and_Failure_Login.sql
- Get_Opened_Transactions_Info.sql
- Get_SQLServer_Startup_Parameters.sql
- Get_SQL_Server_Agent_Information.sql
- Get_SQL_Server_Backup_Directory.sql
- Get_SQL_Server_NUMA_Memory.sql
- Get_Statistics_Details.sql
- Get_Table_Hierarchy.sql
- Get_Table_and_Index_Storage_Size.sql
- Get_latches_Objects.sql
- GoogleJobTimeline.sql
- How_much_will_it_cost_or_save_to_rebuild_that_index.sql
- How_old_your_backups.sql
- How_to_Find_Queries_Using_an_Index.sql
- How_to_obtain_the_deadlocks_on_Azure.sql
- IN_Memory_Example_2014.sql
- IN_Memory_Example_2017.sql
- IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql
- Identify_All_Logins_With_No_Associated_Default_Database_User.sql
- Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql
- Index Breakdown.sql
- Index_Creating_Info.sql
- Indexes_Script_Out.sql
- Job_AG_Failover_Detected.sql
- Job_AG_Resume_Data_Movement.sql
- Jobs_Detailed_History.sql
- Jobs_Find_And_Replace_Text.sql
- Jobs_Get_Runing_info.sql
- LatchStats.sql
- Line_Of_Codes_In_database.sql
- Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql
- MAXDOP_recommendation.sql
- MaxDop_2016_and_higher.sql
- MaxServerMemoryCalculator.sql
- Memory_Consumption_By_Object.sql
- MisleadingSQLServerPerformanceCounters.sql
- Monitor_Deadlocks_with_Extended_Events.sql
- Move_tempdb.sql
- New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql
- Numbers_DATALENGTH.sql
- Objects_Size_In_Database.sql
- Overview_HADR_AlwaysOn_Local_Replica_Server.sql
- PIVOT_Columns_generator.sql
- Partial_Restore_Demo.sql
- Pattern_Match.sql
- PowerSavingCheck.sql
- Queries_vulnerable_to_SQL_injection.sql
- Queries_with_parallelism.sql
- QueryActiveDirectory.sql
- Query_Store_Export.sql
- README.md
- Read_Default_Trace.sql
- Read_Error_Log_File.sql
- Read_errorlog.sql
- Remove_Leading_and_Trailing_Backward_and_Forward_Slashes.sql
- RenameDefaultConstraints.sql
- Reseed_Identity_Column_Value_To_Last_Value.sql
- Restore_Database_Dynamic_SQL.sql
- Restore_script_for_Ola_Hallengren_backup.sql
- Ring_Bufer_Analyze.sql
- Run_scripts.bat
- SQL Managed Instance Diagnostic Information Queries.sql
- SQL Server 2005 Diagnostic Information Queries.sql
- SQL Server 2008 Diagnostic Information Queries.sql
- SQL Server 2008 R2 Diagnostic Information Queries.sql
- SQL Server 2012 Diagnostic Information Queries.sql
- SQL Server 2014 Diagnostic Information Queries.sql
- SQL Server 2016 Diagnostic Information Queries.sql
- SQL Server 2016 SP1 Diagnostic Information Queries.sql
- SQL Server 2016 SP2 Diagnostic Information Queries.sql
- SQL Server 2017 Diagnostic Information Queries.sql
- SQL Server 2019 Diagnostic Information Queries.sql
- SQLServer_Memory_Information.sql
- SQL_Azure_Approximate_Datetime_Restart.sql
- SQL_Server_Defaults.sql
- SQL_Server_Fixed_Role_Permissions.sql
- Save_Error_Log_To_Table.sql
- Search_Script.sql
- Security_Audit_Report.sql
- Selects_That_Cause_Writes.sql
- Server_Parameters.sql
- Show all permissions in a database.sql
- ShredDeadlockGraph.sql
- ShredDeadlockGraph_Sample1.xml
- ShredDeadlockGraph_Sample2.xml
- Shredding_XML_Data_From_Extended_Events.sql
- Simulate_Permissions_Logins_Change.sql
- Simulate_SQL_Server_Users_Hack.sql
- Sort_SQL_Server_Tables_into_similarly_sized_buckets.sql
- Sort_UID_Demo.sql
- Space used by object.sql
- SpaceusedByTable.sql
- SplitFileGroup.sql
- Stop_long-running_SQL_Server_Agent_Jobs.sql
- Suspect_Database_Pages.sql
- Table_Count_Fast_Alternatives.sql
- Table_Parameters.sql
- Tempdb_Contention.sql
- Temporal_Table_Maker.sql
- Test_job.sql
- Truncate log file.sql
- TuneYourIndexingStrategyWithDMVs.sql
- UnPivot_Output_Restore_Headeronly.sql
- Uppercase_All_String_Columns.sql
- Using_OPENROWSET_to_Query_Excel.sql
- VLF_Info.sql
- Visualizing_Agent_Jobs_in_SSMS.sql
- Visualizing_VLF.sql
- Wait_Statistics.sql
- Wait_Statistics_Snapshot.sql
- What_Agent_Job_is_Running.sql
- When_SQL_Server_Was_Installed.sql
- Which_Filegroup_is_that_Partition_Using.sql
- Which_Indexes_are_not_Used.sql
- Which_databases_were_backed_up_and_when.sql
- Which_sp_configure_Options_Clear_the_Plan_Cache.sql
- WhiteListIPTable.sql
- Who_dropped_altered_database_object.sql
- Who_dropped_database.sql
- Windows logins not in AD.sql
- glen_berry_diagnostic_queries_links.txt
- mssql2csv.R
- tempdb_Information.sql
- tempdb_usage.sql
Solution
Stored_Procedure
User_Defined_Function
Utilities
.gitattributes
.gitignore
CONTRIBUTING.md
LICENSE
README.md
SQL Server DBCC List.md
SQL Server Data Types.md
SQL Server Drivers.md
SQL Server Edition.md
SQL Server Hints.md
SQL Server Licensing.md
SQL Server Name Convention and T-SQL Programming Style.md
SQL Server People.md
SQL Server Trace Flag.md
SQL Server Version.md

Scripts

Fix Enable_Statement to select the correct EnableTriggerStatement ins…

Jul 23, 2025

ef4ab59 · Jul 23, 2025

Name	Name	Last commit message	Last commit date
parent directory ..
Trace_Flag	Trace_Flag	Add trace flag 8727	Apr 7, 2020
Adding_Trace_Flags_To_Startup_Parameters.sql	Adding_Trace_Flags_To_Startup_Parameters.sql	Update Adding_Trace_Flags_To_Startup_Parameters.sql	Dec 15, 2024
AutoGuessingForeignKeyConstraints.sql	AutoGuessingForeignKeyConstraints.sql	Added some SQL scripts	May 26, 2017
Auto_Generate_Database_Documentation.sql	Auto_Generate_Database_Documentation.sql	Add Auto_Generate_Database_Documentation script	Mar 30, 2018
Azure SQL Database Diagnostic Information Queries.sql	Azure SQL Database Diagnostic Information Queries.sql	DMVs update for 2020-09	Sep 21, 2020
Backup_Restore_What’s_My_Status.sql	Backup_Restore_What’s_My_Status.sql	Add SQL script backup/restore status	Jan 30, 2017
Bad_Query_Example_13_JOINS.sql	Bad_Query_Example_13_JOINS.sql	Add Bad_Query_Example_13_JOINS script	Jul 5, 2020
Benchmark_TSQL.R	Benchmark_TSQL.R	Update Benchmark_TSQL.R	Jan 19, 2018
Blocked_Session.sql	Blocked_Session.sql	Add Kenneth Fisher blocked session script	Jan 19, 2017
Bufer_Cache_Info.sql	Bufer_Cache_Info.sql	Add Bufer Cache Information script	Apr 30, 2018
BufferPoolExtension.sql	BufferPoolExtension.sql	Add BufferPoolExtension to scripts	Jun 13, 2017
Build_CREATE_TABLE_statement_using_dm_exec_describe_first_result_set.sql	Build_CREATE_TABLE_statement_using_dm_exec_describe_first_result_set.sql	Add new pretty good scripts	Jul 28, 2019
CPU_Utilization.sql	CPU_Utilization.sql	[CLEANUP] Change line breaks	Sep 6, 2016
CPU_Utilization_Graphical_form.sql	CPU_Utilization_Graphical_form.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Cached_Data_Per_Object_in_Memory.sql	Cached_Data_Per_Object_in_Memory.sql	Add Cached Data Per Object in Memory script	May 31, 2021
Change_NonDefault_Collation_for_all_tables.sql	Change_NonDefault_Collation_for_all_tables.sql	Add new pretty good scripts	Feb 6, 2019
CheckSpectreMeltdownStatus.sql	CheckSpectreMeltdownStatus.sql	Add CheckSpectreMeltdownStatus script	Oct 6, 2019
Check_Reserved_Words_For_Object_Names.sql	Check_Reserved_Words_For_Object_Names.sql	Add Check_Reserved_Words_For_Object_Names.sql script	Dec 29, 2018
Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql	Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql	Add new useful scripts	Sep 27, 2017
Checkpoint_XE.sql	Checkpoint_XE.sql	Fix Checkpoint_XE script	Oct 1, 2021
Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example.sql	Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example.sql	Add Code_Reuse_With_Dynamic_SQL_and_Temp_Procedures_Example script	Apr 18, 2019
Compare_2_tables_by_column_names.sql	Compare_2_tables_by_column_names.sql	Add new function and script	Sep 23, 2017
Compare_Tables_With_Matching_Columns.sql	Compare_Tables_With_Matching_Columns.sql	Added script to find tables with matching columns by name	Aug 27, 2022
Compress_Tables_And_Indexes.sql	Compress_Tables_And_Indexes.sql	Add Memory_Consumption_By_Object script	Sep 19, 2019
Configure_SQL_Agent_Alerts.sql	Configure_SQL_Agent_Alerts.sql	Add Glenn Berry Configure SQL Agent Alerts scripts	Feb 6, 2018
Count character matches.sql	Count character matches.sql	Initial commit	May 13, 2015
Count_Database_Reads_and_Writes.sql	Count_Database_Reads_and_Writes.sql	Add Count_Database_Reads_and_Writes script	Apr 15, 2020
Create_2_Million_Tables.sql	Create_2_Million_Tables.sql	Update and rename Create_2_Millions_Tables.sql to Create_2_Million_Ta…	Nov 22, 2020
Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql	Create_JOIN_Query_Between_Multiple_Tables_Dynamically.sql	Fix some bugs and code formating	Apr 23, 2019
Current_Running_Queries.sql	Current_Running_Queries.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Current_Running_Tasks_and_Server_Info.sql	Current_Running_Tasks_and_Server_Info.sql	Add Dedicated Admin Connection configuration	Nov 26, 2016
DBCC_CHECKDB_Latest_date.sql	DBCC_CHECKDB_Latest_date.sql	Add udf_SeeAccessControlChanges function and test script	Jan 28, 2019
Data_Dictionary_Information.sql	Data_Dictionary_Information.sql	Add Data Dictionary Information script	Feb 17, 2018
Database_Mail_Configuration.sql	Database_Mail_Configuration.sql	[FEATURE] Add Database Mail Configuration script	Oct 31, 2016
Database_Mail_Problems.sql	Database_Mail_Problems.sql	Add Database Mail Problems queries	Jun 11, 2018
Databases_Report.sql	Databases_Report.sql	Update Databases_Report script, change SELECT first line recommendation	Nov 14, 2019
Date_Calendar_Cross-Reference_Table.sql	Date_Calendar_Cross-Reference_Table.sql	Update and rename Date Calendar Cross-Reference Table.sql to Date_Cal…	Aug 28, 2018
Date_Format_Cheat_Sheet.sql	Date_Format_Cheat_Sheet.sql	[FEATURE] Add Date_Format_Cheat_Sheet script	Nov 15, 2016
Decrypt T-SQL module.sql	Decrypt T-SQL module.sql	Add config for Dedicated Administrator Connection	Nov 30, 2016
Delete_Login_And_All_Users.sql	Delete_Login_And_All_Users.sql	Add new script and fix some typos	Jul 1, 2019
DetermineSpaceWithinSQLDatabaseFiles.sql	DetermineSpaceWithinSQLDatabaseFiles.sql	Add 4 SQL script in Scripts	Aug 9, 2017
Disable_Enable_All_Triggers_In_Database.sql	Disable_Enable_All_Triggers_In_Database.sql	Fix Enable_Statement to select the correct EnableTriggerStatement ins…	Jul 23, 2025
Disabling_Jobs_Schedules.sql	Disabling_Jobs_Schedules.sql	Add Disabling_Jobs_Schedules script	Apr 18, 2020
Drop_all_objects_in_schema.sql	Drop_all_objects_in_schema.sql	Add new useful scripts	Nov 13, 2017
Dynamic_GRANT_Generation.sql	Dynamic_GRANT_Generation.sql	Add Dynamic_GRANT_generation script	Feb 9, 2020
DynamicallyGenerateDMAStatement.sql	DynamicallyGenerateDMAStatement.sql	Add Scripts	Jun 23, 2017
Enable Microsoft.ACE.OLEDB.12.0.sql	Enable Microsoft.ACE.OLEDB.12.0.sql	Fix Ad Hoc Distributed Queries enable script	Apr 18, 2017
Enabling_Jobs_Schedules.sql	Enabling_Jobs_Schedules.sql	Add Enabling_Jobs_Schedules script	Apr 19, 2020
Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql	Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql	Fix typos - extra comma	Aug 3, 2017
Extract_Scale_Part_From_Decimal_Number.sql	Extract_Scale_Part_From_Decimal_Number.sql	Add new pretty good scripts	Feb 6, 2019
Failed_SQL_Server_Agent_Jobs_With_Restart_Command.sql	Failed_SQL_Server_Agent_Jobs_With_Restart_Command.sql	Fix column names for case sensitive instances	Feb 11, 2019
Fast_alternative_to_sp_WhoIsActive.sql	Fast_alternative_to_sp_WhoIsActive.sql	Add awesome free ebook and Fast_alternative_to_sp_WhoIsActive script	Feb 10, 2019
FindDBConnectionLeaks.sql	FindDBConnectionLeaks.sql	Add 3 sql server scripts	Aug 2, 2017
FindLongRunningJobSteps.sql	FindLongRunningJobSteps.sql	Add 3 sql server scripts	Aug 2, 2017
FindTablesWithSimilarTableStructure.sql	FindTablesWithSimilarTableStructure.sql	Added some SQL scripts	May 26, 2017
Find_Foreign_Key_Chains_For_Tables.sql	Find_Foreign_Key_Chains_For_Tables.sql	Improve Find_Foreign_Key_Chains_For_Tables.sql script	Aug 24, 2019
Find_Maximum_Float_Values.sql	Find_Maximum_Float_Values.sql	Add Find_Maximum_Float_Values.sql	Oct 30, 2019
Find_Non_Sargable_Queries.sql	Find_Non_Sargable_Queries.sql	Add Find_Non_Sargable_Queries script	Aug 22, 2017
Find_Not_Used_Legacy_Tables.sql	Find_Not_Used_Legacy_Tables.sql	Adapt script for case sensitive instance	Mar 22, 2019
Find_Object_Dependecy.sql	Find_Object_Dependecy.sql	Add Find_Object_Dependecy script	Apr 20, 2018
Find_SQL_Server_Integer_Columns_to_Make_Skinnier.sql	Find_SQL_Server_Integer_Columns_to_Make_Skinnier.sql	Add PRINT xml magic	Aug 15, 2019
Find_Status_of_SQL_Server_Statistics.sql	Find_Status_of_SQL_Server_Statistics.sql	Add Find_Status_of_SQL_Server_Statistics script	Jun 17, 2019
Find_Synonyms_for_nested_objects_in_the_different_databases.sql	Find_Synonyms_for_nested_objects_in_the_different_databases.sql	Add new useful scripts	Sep 27, 2017
Find_Synonyms_for_nested_objects_in_the_same_database.sql	Find_Synonyms_for_nested_objects_in_the_same_database.sql	Add new useful scripts	Sep 27, 2017
Find_Weak_Passwords.sql	Find_Weak_Passwords.sql	Add Find_Weak_Passwords script	Aug 17, 2019
Find_and_fix_that_troublesome_Windows_Power_setting.sql	Find_and_fix_that_troublesome_Windows_Power_setting.sql	Add Find_and_fix_that_troublesome_Windows_Power_setting script	Sep 10, 2019
FindingImplicitColumnConversionsInPlanCache.sql	FindingImplicitColumnConversionsInPlanCache.sql	Add 4 SQL script in Scripts	Aug 9, 2017
FindingSpecificColumns.sql	FindingSpecificColumns.sql	Added some SQL scripts	May 26, 2017
Finding_Blocking_Queries.sql	Finding_Blocking_Queries.sql	Add scripts and procedure	Mar 13, 2017
Finding_Host_Names_for_Failed_login_attempts.sql	Finding_Host_Names_for_Failed_login_attempts.sql	Add Finding_Host_Names_for_Failed_login_attempts script	Aug 13, 2019
Fix_The_Broken_Dependencies_On_All_Objects.sql	Fix_The_Broken_Dependencies_On_All_Objects.sql	Improve Find_Foreign_Key_Chains_For_Tables.sql script	Aug 24, 2019
Foreign_Key_batch_rename.sql	Foreign_Key_batch_rename.sql	Some typos fixes and renamed files	Feb 12, 2017
Foreign_Keys_With_No_Index.sql	Foreign_Keys_With_No_Index.sql	Add Foreign_Keys_With_No_Index script	Jun 18, 2019
GenerateTSQLTimeSlices.sql	GenerateTSQLTimeSlices.sql	Add 4 SQL script in Scripts	Aug 9, 2017
Generate_BIML_Script.sql	Generate_BIML_Script.sql	Add Generate_BIML_Script	Jun 16, 2019
Generate_Restore_Script_From_Backup_Folder.sql	Generate_Restore_Script_From_Backup_Folder.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Generate_table_definition_to_match_query.sql	Generate_table_definition_to_match_query.sql	Fix some typos and errors	Apr 17, 2019
GetResourceNameFromBlockedProcessReport.sql	GetResourceNameFromBlockedProcessReport.sql	Added some SQL scripts	May 26, 2017
Get_Amazon_RDS_Instance_Size.sql	Get_Amazon_RDS_Instance_Size.sql	Add Get_Amazon_RDS_Instance_Size script	Aug 2, 2019
Get_CPU_Usage_Per_Database.sql	Get_CPU_Usage_Per_Database.sql	Add new useful information	Nov 30, 2019
Get_Coulmn_Statistics_By_Name.sql	Get_Coulmn_Statistics_By_Name.sql	Add Get_Coulmn_Statistics_By_Name script	Dec 3, 2019
Get_Create_or_Alter_Index_Progress.sql	Get_Create_or_Alter_Index_Progress.sql	Add Get_Create_or_Alter_Index_Progress script	Dec 2, 2019
Get_Database_Size_With_Graph.sql	Get_Database_Size_With_Graph.sql	Add Get_Database_Size_With_Graph script	Dec 23, 2017
Get_Identity_Column_Information.sql	Get_Identity_Column_Information.sql	Add Get_Identity_Column_Information script	Apr 25, 2019
Get_Latest_Success_and_Failure_Login.sql	Get_Latest_Success_and_Failure_Login.sql	Add Get_Latest_Success_and_Failure_Login script	Apr 17, 2020
Get_Opened_Transactions_Info.sql	Get_Opened_Transactions_Info.sql	Add Get_Opened_Transactions_Info script	Nov 23, 2020
Get_SQLServer_Startup_Parameters.sql	Get_SQLServer_Startup_Parameters.sql	Add 2 new useful scripts	Feb 10, 2018
Get_SQL_Server_Agent_Information.sql	Get_SQL_Server_Agent_Information.sql	Add new articles and script Get_SQL_Server_Agent_Information	Mar 13, 2018
Get_SQL_Server_Backup_Directory.sql	Get_SQL_Server_Backup_Directory.sql	Add 2 new useful scripts	Feb 10, 2018
Get_SQL_Server_NUMA_Memory.sql	Get_SQL_Server_NUMA_Memory.sql	Add Get_SQL_Server_NUMA_Memory script	Sep 18, 2019
Get_Statistics_Details.sql	Get_Statistics_Details.sql	Add SQL script Get_Statistics_Details	Feb 27, 2017
Get_Table_Hierarchy.sql	Get_Table_Hierarchy.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Get_Table_and_Index_Storage_Size.sql	Get_Table_and_Index_Storage_Size.sql	Improve Get_Table_and_Index_Storage_Size script and usp_bcpUnloadSele…	Oct 24, 2019
Get_latches_Objects.sql	Get_latches_Objects.sql	Add Get_latches_Objects script	May 4, 2018
GoogleJobTimeline.sql	GoogleJobTimeline.sql	[FEATURE] Add Google Job Timeline script	Oct 28, 2016
How_much_will_it_cost_or_save_to_rebuild_that_index.sql	How_much_will_it_cost_or_save_to_rebuild_that_index.sql	Add How_much_will_it_cost_or_save_to_rebuild_that_index script	Sep 8, 2019
How_old_your_backups.sql	How_old_your_backups.sql	Add How old your backups script	Jan 7, 2017
How_to_Find_Queries_Using_an_Index.sql	How_to_Find_Queries_Using_an_Index.sql	Add SQL scripts	Jan 30, 2017
How_to_obtain_the_deadlocks_on_Azure.sql	How_to_obtain_the_deadlocks_on_Azure.sql	Add Azure system_health alternative and script for azure deadlock ana…	Mar 18, 2019
IN_Memory_Example_2014.sql	IN_Memory_Example_2014.sql	Fix some typos and errors	Apr 17, 2019
IN_Memory_Example_2017.sql	IN_Memory_Example_2017.sql	Fix some bugs and code formating	Apr 23, 2019
IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql	IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql	Added some SQL scripts	May 26, 2017
Identify_All_Logins_With_No_Associated_Default_Database_User.sql	Identify_All_Logins_With_No_Associated_Default_Database_User.sql	Add Identify All Logins With No Associated Default Database User script	Jan 25, 2017
Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql	Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql	Add Identifying In-Memory Objects script	Dec 24, 2016
Index Breakdown.sql	Index Breakdown.sql	Added index breakdown script	Jan 14, 2016
Index_Creating_Info.sql	Index_Creating_Info.sql	Add awesome Solomon Rutzky Index_Creating_Info.sql script	Aug 11, 2021
Indexes_Script_Out.sql	Indexes_Script_Out.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Job_AG_Failover_Detected.sql	Job_AG_Failover_Detected.sql	Add jobs for monitoring AG	Aug 9, 2020
Job_AG_Resume_Data_Movement.sql	Job_AG_Resume_Data_Movement.sql	Add jobs for monitoring AG	Aug 9, 2020
Jobs_Detailed_History.sql	Jobs_Detailed_History.sql	Add Jobs_Detailed_History script	Sep 4, 2019
Jobs_Find_And_Replace_Text.sql	Jobs_Find_And_Replace_Text.sql	Add Find_and_fix_that_troublesome_Windows_Power_setting script	Sep 9, 2019
Jobs_Get_Runing_info.sql	Jobs_Get_Runing_info.sql	Add Jobs_Get_Runing_info script	Aug 10, 2020
LatchStats.sql	LatchStats.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Line_Of_Codes_In_database.sql	Line_Of_Codes_In_database.sql	Add Line_Of_Codes_In_database script by Pinal Dave	Nov 8, 2018
Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql	Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql	[FEATURE] Add some articles	Oct 27, 2016
MAXDOP_recommendation.sql	MAXDOP_recommendation.sql	Update Maxdop script	Jun 9, 2018
MaxDop_2016_and_higher.sql	MaxDop_2016_and_higher.sql	Add MaxDop_2016_and_higher script	Sep 7, 2020
MaxServerMemoryCalculator.sql	MaxServerMemoryCalculator.sql	Add bornsql scripts	Jul 11, 2017
Memory_Consumption_By_Object.sql	Memory_Consumption_By_Object.sql	Update some script documentation and format it	Feb 5, 2020
MisleadingSQLServerPerformanceCounters.sql	MisleadingSQLServerPerformanceCounters.sql	Add 4 SQL script in Scripts	Aug 9, 2017
Monitor_Deadlocks_with_Extended_Events.sql	Monitor_Deadlocks_with_Extended_Events.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Move_tempdb.sql	Move_tempdb.sql	Improve Move tempdb script	Jun 15, 2019
New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql	New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql	Add New Default Database Assignment For Any Login Missing Their Defau…	Jan 26, 2017
Numbers_DATALENGTH.sql	Numbers_DATALENGTH.sql	Add ANSI column to data types, update data types recommendations	Oct 25, 2019
Objects_Size_In_Database.sql	Objects_Size_In_Database.sql	Improve object size calculation script	Jun 26, 2019
Overview_HADR_AlwaysOn_Local_Replica_Server.sql	Overview_HADR_AlwaysOn_Local_Replica_Server.sql	Add new nice script, useful links, fix PRINT truncate issue	Feb 16, 2019
PIVOT_Columns_generator.sql	PIVOT_Columns_generator.sql	Add PIVOT_Columns_generator script	Jan 24, 2020
Partial_Restore_Demo.sql	Partial_Restore_Demo.sql	Add Partial_Restore_Demo script	May 7, 2018
Pattern_Match.sql	Pattern_Match.sql	Add new pretty good scripts	Jul 28, 2019
PowerSavingCheck.sql	PowerSavingCheck.sql	Add bornsql scripts	Jul 11, 2017
Queries_vulnerable_to_SQL_injection.sql	Queries_vulnerable_to_SQL_injection.sql	Add Queries vulnerable to SQL injection	Sep 4, 2017
Queries_with_parallelism.sql	Queries_with_parallelism.sql	Add Queries_with_parallelism script	Mar 14, 2018
QueryActiveDirectory.sql	QueryActiveDirectory.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Query_Store_Export.sql	Query_Store_Export.sql	Add Query_Store_Export.sql script	Jan 26, 2020
README.md	README.md	Add Auto_Generate_Database_Documentation script	Mar 30, 2018
Read_Default_Trace.sql	Read_Default_Trace.sql	Add Read_Default_Trace script	Mar 8, 2020
Read_Error_Log_File.sql	Read_Error_Log_File.sql	Update Read_Error_Log_File script	Mar 26, 2019
Read_errorlog.sql	Read_errorlog.sql	Add Read_errorlog script	Aug 31, 2019
Remove_Leading_and_Trailing_Backward_and_Forward_Slashes.sql	Remove_Leading_and_Trailing_Backward_and_Forward_Slashes.sql	Add Remove_Leading_and_Trailing_Backward_and_Forward_Slashes script	Oct 16, 2019
RenameDefaultConstraints.sql	RenameDefaultConstraints.sql	Add RenameDefaultConstraints to Scripts	Jul 3, 2017
Reseed_Identity_Column_Value_To_Last_Value.sql	Reseed_Identity_Column_Value_To_Last_Value.sql	Add Reseed_Identity_Column_Value_To_Last_Value script	May 3, 2019
Restore_Database_Dynamic_SQL.sql	Restore_Database_Dynamic_SQL.sql	Add Restore Database Dynamic SQL script, fix typos	Feb 4, 2018
Restore_script_for_Ola_Hallengren_backup.sql	Restore_script_for_Ola_Hallengren_backup.sql	[CLEANUP] Change line breaks	Sep 6, 2016
Ring_Bufer_Analyze.sql	Ring_Bufer_Analyze.sql	Add RingBufferXML analyze script	May 31, 2017
Run_scripts.bat	Run_scripts.bat	Add run multiply scripts bat file	Jul 30, 2017
SQL Managed Instance Diagnostic Information Queries.sql	SQL Managed Instance Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2005 Diagnostic Information Queries.sql	SQL Server 2005 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2008 Diagnostic Information Queries.sql	SQL Server 2008 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2008 R2 Diagnostic Information Queries.sql	SQL Server 2008 R2 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2012 Diagnostic Information Queries.sql	SQL Server 2012 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2014 Diagnostic Information Queries.sql	SQL Server 2014 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2016 Diagnostic Information Queries.sql	SQL Server 2016 Diagnostic Information Queries.sql	Update Diagnostic Information Queries to 2019-12	Dec 4, 2019
SQL Server 2016 SP1 Diagnostic Information Queries.sql	SQL Server 2016 SP1 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2016 SP2 Diagnostic Information Queries.sql	SQL Server 2016 SP2 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2017 Diagnostic Information Queries.sql	SQL Server 2017 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQL Server 2019 Diagnostic Information Queries.sql	SQL Server 2019 Diagnostic Information Queries.sql	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
SQLServer_Memory_Information.sql	SQLServer_Memory_Information.sql	Update some script documentation and format it	Feb 5, 2020
SQL_Azure_Approximate_Datetime_Restart.sql	SQL_Azure_Approximate_Datetime_Restart.sql	Add SQL_Azure_Approximate_Datetime_Restart script	Oct 14, 2018
SQL_Server_Defaults.sql	SQL_Server_Defaults.sql	Add SQL_Server_Defaults.sql script	Nov 6, 2018
SQL_Server_Fixed_Role_Permissions.sql	SQL_Server_Fixed_Role_Permissions.sql	Add scripts and procedure	Mar 13, 2017
Save_Error_Log_To_Table.sql	Save_Error_Log_To_Table.sql	Add Save_Error_Log_To_Table script	Jun 6, 2018
Search_Script.sql	Search_Script.sql	[OTHER] Add search script	Apr 16, 2016
Security_Audit_Report.sql	Security_Audit_Report.sql	Add new errors and links, fix some typos	Sep 30, 2018
Selects_That_Cause_Writes.sql	Selects_That_Cause_Writes.sql	Add Selects_That_Cause_Writes script	Apr 8, 2019
Server_Parameters.sql	Server_Parameters.sql	Add SQL Server parameters script	Jul 31, 2017
Show all permissions in a database.sql	Show all permissions in a database.sql	[FEATURE] Add Daniel Hutmacher nice scripts	Aug 26, 2016
ShredDeadlockGraph.sql	ShredDeadlockGraph.sql	Add Scripts	Jun 23, 2017
ShredDeadlockGraph_Sample1.xml	ShredDeadlockGraph_Sample1.xml	Add Scripts	Jun 23, 2017
ShredDeadlockGraph_Sample2.xml	ShredDeadlockGraph_Sample2.xml	Add Scripts	Jun 23, 2017
Shredding_XML_Data_From_Extended_Events.sql	Shredding_XML_Data_From_Extended_Events.sql	Add new nice script, useful links, fix PRINT truncate issue	Feb 16, 2019
Simulate_Permissions_Logins_Change.sql	Simulate_Permissions_Logins_Change.sql	Add udf_SeeAccessControlChanges function and test script	Jan 28, 2019
Simulate_SQL_Server_Users_Hack.sql	Simulate_SQL_Server_Users_Hack.sql	Add Simulate_SQL_Server_Users_Hack script	May 4, 2019
Sort_SQL_Server_Tables_into_similarly_sized_buckets.sql	Sort_SQL_Server_Tables_into_similarly_sized_buckets.sql	Add Sort SQL Server Tables into similarly sized buckets script	Jun 21, 2018
Sort_UID_Demo.sql	Sort_UID_Demo.sql	Add Sort_UID_Demo script	Apr 14, 2020
Space used by object.sql	Space used by object.sql	[FEATURE] Add description to repo folders, fix some typos	Oct 29, 2015
SpaceusedByTable.sql	SpaceusedByTable.sql	Add SpaceusedByTable script	May 12, 2016
SplitFileGroup.sql	SplitFileGroup.sql	Add split file group script and some useful links	Mar 23, 2017
Stop_long-running_SQL_Server_Agent_Jobs.sql	Stop_long-running_SQL_Server_Agent_Jobs.sql	Add Stop long-running SQL Server Agent Jobs scripts	Sep 6, 2017
Suspect_Database_Pages.sql	Suspect_Database_Pages.sql	Add Suspect Database Pages script	Aug 23, 2017
Table_Count_Fast_Alternatives.sql	Table_Count_Fast_Alternatives.sql	Add new articles, fix some bugs and code formating	Apr 24, 2019
Table_Parameters.sql	Table_Parameters.sql	Comment some columns for 2014 version compatibility	Apr 30, 2019
Tempdb_Contention.sql	Tempdb_Contention.sql	[FEATURE] Add Temdb Contention Script	Nov 4, 2016
Temporal_Table_Maker.sql	Temporal_Table_Maker.sql	Add Temporal Table Maker script	Jan 2, 2018
Test_job.sql	Test_job.sql	Add Test_job script	May 2, 2018
Truncate log file.sql	Truncate log file.sql	Initial commit	May 13, 2015
TuneYourIndexingStrategyWithDMVs.sql	TuneYourIndexingStrategyWithDMVs.sql	Add TuneYourIndexingStrategyWithDMVs to scripts	Jun 14, 2017
UnPivot_Output_Restore_Headeronly.sql	UnPivot_Output_Restore_Headeronly.sql	Add stored procedures and script	Mar 9, 2017
Uppercase_All_String_Columns.sql	Uppercase_All_String_Columns.sql	Add SSMS 18.0 RC release, update SSMS tips, add true uppercase for un…	Mar 31, 2019
Using_OPENROWSET_to_Query_Excel.sql	Using_OPENROWSET_to_Query_Excel.sql	Add Using_OPENROWSET_to_Query_Excel.sql script	Nov 1, 2019
VLF_Info.sql	VLF_Info.sql	Add new script and fix some typos	Jul 1, 2019
Visualizing_Agent_Jobs_in_SSMS.sql	Visualizing_Agent_Jobs_in_SSMS.sql	Add Visualizing Agent Jobs in SSMS script	Dec 8, 2016
Visualizing_VLF.sql	Visualizing_VLF.sql	Fix Collation case sensitive issue and format code	Dec 15, 2018
Wait_Statistics.sql	Wait_Statistics.sql	Update Wait_Statistics script	Aug 2, 2020
Wait_Statistics_Snapshot.sql	Wait_Statistics_Snapshot.sql	Add Wait_Statistics_Snapshot script	Aug 5, 2020
What_Agent_Job_is_Running.sql	What_Agent_Job_is_Running.sql	Add What Agent Job is Running script	Jan 5, 2017
When_SQL_Server_Was_Installed.sql	When_SQL_Server_Was_Installed.sql	Add When_SQL_Server_Was_Installed script and nice article	Apr 29, 2019
Which_Filegroup_is_that_Partition_Using.sql	Which_Filegroup_is_that_Partition_Using.sql	Some typos fixes and renamed files	Feb 12, 2017
Which_Indexes_are_not_Used.sql	Which_Indexes_are_not_Used.sql	[FEATURE] Add Which Indexes are not Used script	Nov 10, 2016
Which_databases_were_backed_up_and_when.sql	Which_databases_were_backed_up_and_when.sql	Add Thomas Rushton to SQL Server People	Oct 14, 2017
Which_sp_configure_Options_Clear_the_Plan_Cache.sql	Which_sp_configure_Options_Clear_the_Plan_Cache.sql	Add Which sp_configure Options Clear the Plan Cache script	Oct 8, 2017
WhiteListIPTable.sql	WhiteListIPTable.sql	Add script WhiteListIPTable with trigger	May 23, 2017
Who_dropped_altered_database_object.sql	Who_dropped_altered_database_object.sql	Add some comments and format script	Mar 26, 2019
Who_dropped_database.sql	Who_dropped_database.sql	Update Who_dropped_database script	Dec 12, 2018
Windows logins not in AD.sql	Windows logins not in AD.sql	[FEATURE] script find windows login not in AD	Feb 3, 2016
glen_berry_diagnostic_queries_links.txt	glen_berry_diagnostic_queries_links.txt	Update SQL Server Diagnostic Queries to 2020-12	Dec 10, 2020
mssql2csv.R	mssql2csv.R	Add mssql2csv.R script	Mar 15, 2020
tempdb_Information.sql	tempdb_Information.sql	Update tempdb information script	Jan 11, 2017
tempdb_usage.sql	tempdb_usage.sql	Add tempdb_usage.sql script	Oct 26, 2018

README.md

Usefull SQL Server Scripts

More than 100 useful scripts for SQL Server

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Files

Scripts

Scripts

README.md

Usefull SQL Server Scripts

Collapse file tree

Files

Scripts

Directory actions

More options

Directory actions

More options

Latest commit

History

Scripts

Folders and files

parent directory

README.md

Usefull SQL Server Scripts