Skip to content

Latest commit

 

History

History
 
 

Scripts

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
AutoGuessingForeignKeyConstraints.sql
AutoGuessingForeignKeyConstraints.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
 
 
Blocked_Session.sql
Blocked_Session.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
 
 
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
 
 
Database_Mail_Configuration.sql
Database_Mail_Configuration.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_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_Statistics_Details.sql
Get_Statistics_Details.sql
 
 
Get_Table_Hierarchy.sql
Get_Table_Hierarchy.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
 
 
ObjectSizes.sql
ObjectSizes.sql
 
 
PowerSavingCheck.sql
PowerSavingCheck.sql
 
 
Queries_vulnerable_to_SQL_injection.sql
Queries_vulnerable_to_SQL_injection.sql
 
 
QueryActiveDirectory.sql
QueryActiveDirectory.sql
 
 
README.md
README.md
 
 
RenameDefaultConstraints.sql
RenameDefaultConstraints.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 2017 Diagnostic Information Queries.sql
SQL Server 2017 Diagnostic Information Queries.sql
 
 
SQL_Server_Fixed_Role_Permissions.sql
SQL_Server_Fixed_Role_Permissions.sql
 
 
Search_Script.sql
Search_Script.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
 
 
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 alternative.sql
Table Count alternative.sql
 
 
Table_Parameters.sql
Table_Parameters.sql
 
 
Table_and_Index_storage_size.sql
Table_and_Index_storage_size.sql
 
 
Table_upload_order.sql
Table_upload_order.sql
 
 
Tempdb_Contention.sql
Tempdb_Contention.sql
 
 
Temporal_Table_Maker.sql
Temporal_Table_Maker.sql
 
 
Truncate log file.sql
Truncate log file.sql
 
 
TuneYourIndexingStrategyWithDMVs.sql
TuneYourIndexingStrategyWithDMVs.sql
 
 
UnPivot_Output_Restore_Headeronly.sql
UnPivot_Output_Restore_Headeronly.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
 
 
What_Agent_Job_is_Running.sql
What_Agent_Job_is_Running.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
 
 

README.md

Usefull SQL Server Scripts

[SQL Server 2016 Diagnostic Information Queries](SQL Server 2016 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2016

[SQL Server 2012 Diagnostic Information Queries](SQL Server 2012 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2012

[SQL Server 2008 R2 Diagnostic Information Queries](SQL Server 2008 R2 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2008

[SQL Server 2008 Diagnostic Information Queries](SQL Server 2008 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2008

[SQL Server 2014 Diagnostic Information Queries](SQL Server 2014 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2014

[SQL Server 2005 Diagnostic Information Queries](SQL Server 2005 Diagnostic Information Queries.sql)

Author: Glenn Alan Berry
Original link: http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-june-2016/
Tested on SQL Server version: 2005

Auto generate SQL Server restore script from backup files in a directory

Author: Greg Robidoux
Original link: https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/ Tested on SQL Server version: 2008/2012/2014/2016

CPU Utilization Graphical form

Author: Slava Murygin
Original link: http://slavasql.blogspot.ru/2016/03/sql-server-cpu-utilization-in-graphical.html
Tested on SQL Server version: 2012/2014

CPU Utilization

Author: Benjamin Nevarez
Original link: http://sqlblog.com/blogs/ben_nevarez/archive/2009/07/26/getting-cpu-utilization-data-from-sql-server.aspx
Tested on SQL Server version: 2014

Restore script for Ola Hallengren backup

Author: Joe O'Connor
Original link: http://www.sqlservercentral.com/scripts/Restore/140540/
Tested on SQL Server version: 2014

Search Script

Author: Ed Pollack
Original link: http://www.sqlshack.com/searching-sql-server-made-easy-building-the-perfect-search-script/
Tested on SQL Server version: 2014

[Table count alternative](Table Count alternative.sql)

Author: Jes Schultz Borland
Original link: http://www.brentozar.com/archive/2014/02/count-number-rows-table-sql-server/
Tested on SQL Server version: 2008/2012/2014/2016

[Foreign Key batch rename](Foreign Key batch rename.sql)

Author: Wes Henriksen
Original link: http://www.brentozar.com/archive/2014/02/count-number-rows-table-sql-server/
Tested on SQL Server version: 2008/2012/2014

[Count character matches](Count character matches.sql)

Author: Sean Smith
Original link: http://www.sqlservercentral.com/scripts/Date/68389/
Tested on SQL Server version: 2008/2012/2014

[Index Breakdown](Index Breakdown.sql)

Author: Sean Smith
Original link: http://www.sqlservercentral.com/scripts/Indexing/104395/
Tested on SQL Server version: 2014

Indexes Script Out

Author: Kendra Little
Original link: http://www.littlekendra.com/2016/05/05/how-to-script-out-indexes-from-sql-server/
Tested on SQL Server version: 2012/2014

Query Active Directory

Author: Ryan Adams
Original link: http://www.ryanjadams.com/2016/03/query-active-directory-sql-server/
Tested on SQL Server version: 2014