Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
Accelerator
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Type
/
to search
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
Dreammaster13
/
sqlserver-kit
Public
forked from
ktaranov/sqlserver-kit
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Wiki
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Wiki
Security and quality
Insights
Files
Expand file tree
master
Breadcrumbs
sqlserver-kit
/
Scripts
/
Copy path
Directory actions
More options
More options
Directory actions
More options
More options
Latest commit
History
History
History
master
Breadcrumbs
sqlserver-kit
/
Scripts
/
Copy path
Top
Folders and files
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
Benchmark_TSQL.R
Benchmark_TSQL.R
Blocked_Session.sql
Blocked_Session.sql
Bufer_Cache_Info.sql
Bufer_Cache_Info.sql
BufferPoolExtension.sql
BufferPoolExtension.sql
CPU_Utilization.sql
CPU_Utilization.sql
CPU_Utilization_Graphical_form.sql
CPU_Utilization_Graphical_form.sql
Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql
Checking_Your_Backup_Paths_Exist_and_Automatically_Create_it.sql
Compare_2_tables_by_column_names.sql
Compare_2_tables_by_column_names.sql
Configure_SQL_Agent_Alerts.sql
Configure_SQL_Agent_Alerts.sql
Count character matches.sql
Count character matches.sql
Current_Running_Queries.sql
Current_Running_Queries.sql
Current_Running_Tasks_and_Server_Info.sql
Current_Running_Tasks_and_Server_Info.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
DetermineSpaceWithinSQLDatabaseFiles.sql
DetermineSpaceWithinSQLDatabaseFiles.sql
Drop_all_objects_in_schema.sql
Drop_all_objects_in_schema.sql
DynamicallyGenerateDMAStatement.sql
DynamicallyGenerateDMAStatement.sql
Enable Microsoft.ACE.OLEDB.12.0.sql
Enable Microsoft.ACE.OLEDB.12.0.sql
Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql
Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql
FindDBConnectionLeaks.sql
FindDBConnectionLeaks.sql
FindLongRunningJobSteps.sql
FindLongRunningJobSteps.sql
FindTablesWithSimilarTableStructure.sql
FindTablesWithSimilarTableStructure.sql
Find_Non_Sargable_Queries.sql
Find_Non_Sargable_Queries.sql
Find_Object_Dependecy.sql
Find_Object_Dependecy.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
FindingImplicitColumnConversionsInPlanCache.sql
FindingImplicitColumnConversionsInPlanCache.sql
FindingSpecificColumns.sql
FindingSpecificColumns.sql
Finding_Blocking_Queries.sql
Finding_Blocking_Queries.sql
Foreign_Key_batch_rename.sql
Foreign_Key_batch_rename.sql
GenerateTSQLTimeSlices.sql
GenerateTSQLTimeSlices.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_Database_Size_With_Graph.sql
Get_Database_Size_With_Graph.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_Statistics_Details.sql
Get_Statistics_Details.sql
Get_Table_Hierarchy.sql
Get_Table_Hierarchy.sql
Get_latches_Objects.sql
Get_latches_Objects.sql
GoogleJobTimeline.sql
GoogleJobTimeline.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
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
Indexes_Script_Out.sql
Indexes_Script_Out.sql
LatchStats.sql
LatchStats.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
MaxServerMemoryCalculator.sql
MaxServerMemoryCalculator.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
ObjectSizes.sql
ObjectSizes.sql
Partial_Restore_Demo.sql
Partial_Restore_Demo.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
README.md
README.md
RenameDefaultConstraints.sql
RenameDefaultConstraints.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 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 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_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
Server_Parameters.sql
Server_Parameters.sql
Show all permissions in a database.sql
Show all permissions in a database.sql
ShredDeadlockGraph.sql
ShredDeadlockGraph.sql
View all files
README.md
Usefull SQL Server Scripts
More than 100 useful scripts for SQL Server
You can’t perform that action at this time.