GitHub - IUGN/t-sql: useful t-sql scripts

IUGN / t-sql Public

forked from cviorel/t-sql

Notifications You must be signed in to change notification settings
Fork 0
Star 0

useful t-sql scripts

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 105 Commits
COMPILATIONS_TRBSH		COMPILATIONS_TRBSH
INDEXES_OPERATIONS		INDEXES_OPERATIONS
NEW SERVER INSTALLATION		NEW SERVER INSTALLATION
PARTITIONING		PARTITIONING
SQLServer_Performance_SQL		SQLServer_Performance_SQL
SSRS		SSRS
ValidateTempdbConfig		ValidateTempdbConfig
dbareports		dbareports
AlwaysOn_ReadOnly_Routing.sql		AlwaysOn_ReadOnly_Routing.sql
AlwaysOn_State_Change_History.sql		AlwaysOn_State_Change_History.sql
AlwaysOn_State_Change_History2.sql		AlwaysOn_State_Change_History2.sql
BACKUP_FILES_REPORT.txt		BACKUP_FILES_REPORT.txt
BACKUP_LIST.sql		BACKUP_LIST.sql
Backup_DB.sql		Backup_DB.sql
Backup_Database_express.docx		Backup_Database_express.docx
Blocking in Current Database.sql		Blocking in Current Database.sql
BlockingProcesses_AUDIT.sql		BlockingProcesses_AUDIT.sql
CPU_USAGE_PROC.sql		CPU_USAGE_PROC.sql
CREATE_ALERTS_AlwaysOn.sql		CREATE_ALERTS_AlwaysOn.sql
CREATE_AUDIT.sql		CREATE_AUDIT.sql
CREATE_AUDIT_SPEC.sql		CREATE_AUDIT_SPEC.sql
CREATE_MAIL_ACCOUNT_AND_PROFILE.sql		CREATE_MAIL_ACCOUNT_AND_PROFILE.sql
CREATE_PLAN_GUIDE.sql		CREATE_PLAN_GUIDE.sql
CREATE_PROC_dbo.GetProcStats.sql		CREATE_PROC_dbo.GetProcStats.sql
CREATE_PROXY_ACCOUNT.sql		CREATE_PROXY_ACCOUNT.sql
CREATE_TABLE_DBA_WhoIsActive_2008.sql		CREATE_TABLE_DBA_WhoIsActive_2008.sql
CURRENT_RUNNING_QUERIES_2.sql		CURRENT_RUNNING_QUERIES_2.sql
CURRENT_RUNNING_QUERY_WITH_PLANS.sql		CURRENT_RUNNING_QUERY_WITH_PLANS.sql
Change_FileGrowth.sql		Change_FileGrowth.sql
Change_Owner_of_MaintenancePlan.sql		Change_Owner_of_MaintenancePlan.sql
CheckForSQL.txt		CheckForSQL.txt
CheckJobExecution.docx		CheckJobExecution.docx
Configuring AlwaysOn Read-Only Routing.sql		Configuring AlwaysOn Read-Only Routing.sql
Create_DBA_sp_tree_locks.sql		Create_DBA_sp_tree_locks.sql
Ctrl_5_who_is_active.sql		Ctrl_5_who_is_active.sql
DATABASE_Users_Collection.sql		DATABASE_Users_Collection.sql
DBA_All_Databases_Sizes.sql		DBA_All_Databases_Sizes.sql
DBA_Operator_create.sql		DBA_Operator_create.sql
DBA_Server_Audit_creation.sql		DBA_Server_Audit_creation.sql
DBA_vProcedureExecInfo.sql		DBA_vProcedureExecInfo.sql
DBA_vStatementExecInfo.sql		DBA_vStatementExecInfo.sql
DBCC_PAGE_info.sql		DBCC_PAGE_info.sql
DB_files_size.sql		DB_files_size.sql
DDL_AUDIT_SB.sql		DDL_AUDIT_SB.sql
DDL_OPERATIONS_FROM_TRACE_REPORT.sql		DDL_OPERATIONS_FROM_TRACE_REPORT.sql
Deadlocks_AUDIT.sql		Deadlocks_AUDIT.sql
DriveLatencyCumulative.sql		DriveLatencyCumulative.sql
DriveSpace.sql		DriveSpace.sql
EnumSqlServer.txt		EnumSqlServer.txt
FIND_in_queryplan.sql		FIND_in_queryplan.sql
FULL-TEXT_Catalog_DMVs.sql		FULL-TEXT_Catalog_DMVs.sql
FULLTEXT_SEARCH.sql		FULLTEXT_SEARCH.sql
FirstResponderKit.zip		FirstResponderKit.zip
Get File Statistics Using fn_virtualfilestats.sql		Get File Statistics Using fn_virtualfilestats.sql
Job_DBA_Backup_Files_Report.sql		Job_DBA_Backup_Files_Report.sql
Job_DBA_Clear_DDL_Log.sql		Job_DBA_Clear_DDL_Log.sql
Job_DBA_Collect_WhoIsActive.sql		Job_DBA_Collect_WhoIsActive.sql
Job_DBA_Daily Cycle Errorlog.sql		Job_DBA_Daily Cycle Errorlog.sql
Job_DBA_Read_SQL_log.sql		Job_DBA_Read_SQL_log.sql
Job_DBA_Report_Free_Space.sql		Job_DBA_Report_Free_Space.sql
Job_DBA_Report_Long_Queries.sql		Job_DBA_Report_Long_Queries.sql
Job_DBA_Weekly Maintenance.sql		Job_DBA_Weekly Maintenance.sql
LDAP_Query.sql		LDAP_Query.sql
LIST_BACKUP_FILES_with_total.sql		LIST_BACKUP_FILES_with_total.sql
LIST_OF_BACKUP_FILES.sql		LIST_OF_BACKUP_FILES.sql
List_jobs_and_schedule_info.sql		List_jobs_and_schedule_info.sql
MANUAL_FAILOVER.sql		MANUAL_FAILOVER.sql
MEMORY_USAGE.sql		MEMORY_USAGE.sql
MEMORY_USAGE_WITH_PLAN.sql		MEMORY_USAGE_WITH_PLAN.sql
MEMORY_USAGE_WITH_TEXT.sql		MEMORY_USAGE_WITH_TEXT.sql
MEMORY_USAGE_extended.sql		MEMORY_USAGE_extended.sql
MEMORY_USAGE_top1.sql		MEMORY_USAGE_top1.sql
MERGE_LoginUsage.sql		MERGE_LoginUsage.sql
MOVE_tempdb_DATABASE.sql		MOVE_tempdb_DATABASE.sql
MSRS_TimeOut.docx		MSRS_TimeOut.docx
MaintenanceSolution.sql		MaintenanceSolution.sql
MyTemplate.xml		MyTemplate.xml
OBJECTS_IN_MEMORY.sql		OBJECTS_IN_MEMORY.sql
OBJECT_BY_SQLTEXT.sql		OBJECT_BY_SQLTEXT.sql
PARALLEL_QUERIES_info.sql		PARALLEL_QUERIES_info.sql
QUERY_PARAMETERS.sql		QUERY_PARAMETERS.sql
READ_AUDIT_FILE.sql		READ_AUDIT_FILE.sql
READ_FROM_TRN.sql		READ_FROM_TRN.sql
READ_FROM_TRN2.sql		READ_FROM_TRN2.sql
REPORT_BACKUP_FILES.txt		REPORT_BACKUP_FILES.txt
REPORT_BACKUP_FILES_TO_FILE.txt		REPORT_BACKUP_FILES_TO_FILE.txt
RESTORE_ALL_LOGS_FROM_FOLDER.sql		RESTORE_ALL_LOGS_FROM_FOLDER.sql
RESTORE_TEST_DB.sql		RESTORE_TEST_DB.sql
ReadErrorLog.sql		ReadErrorLog.sql
Reporting Services service doesn.docx		Reporting Services service doesn.docx
SB_SETUP.sql		SB_SETUP.sql
SELECT_FROM_DEFAULT_TRACE.sql		SELECT_FROM_DEFAULT_TRACE.sql
SELECT_ORDER_info.sql		SELECT_ORDER_info.sql
SELECT_SERVER_FACETS.sql		SELECT_SERVER_FACETS.sql
SERVERPROPERTY.sql		SERVERPROPERTY.sql
SERVERS_INFO_2005_2008.sql		SERVERS_INFO_2005_2008.sql
SERVER_VERSION_DATABASE_SIZE_INFO.sql		SERVER_VERSION_DATABASE_SIZE_INFO.sql
SQL Logins with passwords same as logins.sql		SQL Logins with passwords same as logins.sql
SQL Server 2016 SP2 Diagnostic Information Queries.sql		SQL Server 2016 SP2 Diagnostic Information Queries.sql
SQLAgent_domain_account.docx		SQLAgent_domain_account.docx