Files

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
- 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
img
.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

Jan 10, 2022

bbd924b · Jan 10, 2022

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

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

Files

Scripts

Scripts

README.md

Usefull SQL Server Scripts

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