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

Update Backup_Restore_What’s_My_Status.sql

Sep 16, 2025

a5e2733 · Sep 16, 2025

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

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