SQLScripts

This repository is a collection of SQL Server scripts I use. Many of these scripts have been pulled down off the internet from others. I make no claim to ownership or authorship for all of these.

Please use at your own risk. And for pete's sake, please test any code you find on the internet before running on production!

Name		Name	Last commit message	Last commit date
Latest commit History 14 Commits
Agent		Agent
Alerts Setup		Alerts Setup
Availability Groups		Availability Groups
Backups Restores		Backups Restores
Brent Ozar		Brent Ozar
Code Samples		Code Samples
Create Problem		Create Problem
DBA DB		DBA DB
Extended Events		Extended Events
Glen Berry		Glen Berry
MySQL		MySQL
New Server Setup		New Server Setup
Ola Hallengren		Ola Hallengren
PowerShell		PowerShell
Replication		Replication
RunBook		RunBook
SQL Saturday		SQL Saturday
SQL Trace		SQL Trace
SQLSkills		SQLSkills
SSIS		SSIS
SSRS		SSRS
SharePoint		SharePoint
XML		XML
!QUICK STATS 2012.sql		!QUICK STATS 2012.sql
!QUICK STATS.sql		!QUICK STATS.sql
ALTER USER WITH LOGIN.sql		ALTER USER WITH LOGIN.sql
Auto Growth Events.sql		Auto Growth Events.sql
Available Space in DB.sql		Available Space in DB.sql
BigTables.sql		BigTables.sql
Blocking Query - sp_who_is_active alternative.sql		Blocking Query - sp_who_is_active alternative.sql
CPU Query.sql		CPU Query.sql
CPU Utilization Graph.sql		CPU Utilization Graph.sql
CXPACKET Top 20 Parallel Queries.sql		CXPACKET Top 20 Parallel Queries.sql
CXPACKET Waiting queries.sql		CXPACKET Waiting queries.sql
Change Object Owner.sql		Change Object Owner.sql
Check Default Isolation Level.sql		Check Default Isolation Level.sql
Constraints - Find Untrusted FK and Check Constraints.sql		Constraints - Find Untrusted FK and Check Constraints.sql
Create_SPROC_Dictionary.sql		Create_SPROC_Dictionary.sql
DB File Free Space.sql		DB File Free Space.sql
DB File Stats.sql		DB File Stats.sql
DBCC CHECKDB - Last Good.sql		DBCC CHECKDB - Last Good.sql
DB_Executor role.sql		DB_Executor role.sql
Data Dictionary.sql		Data Dictionary.sql
Database Sizes.sql		Database Sizes.sql
Deadlock - Traceflags.sql		Deadlock - Traceflags.sql
Deadlock Trace.sql		Deadlock Trace.sql
Deadlocks - Read deadlock XML.sql		Deadlocks - Read deadlock XML.sql
Default Database Paths.sql		Default Database Paths.sql
Default Trace - Object Auditing.sql		Default Trace - Object Auditing.sql
Default Trace - Queries.sql		Default Trace - Queries.sql
Errors - Severity 20 or greater - XEvents.sql		Errors - Severity 20 or greater - XEvents.sql
Event Log Reader.sql		Event Log Reader.sql
Extended Events - Metadata.sql		Extended Events - Metadata.sql
Extended Events - Setup and Query.sql		Extended Events - Setup and Query.sql
Extended Properties - Add extended properties comments to Tables and Columns.sql		Extended Properties - Add extended properties comments to Tables and Columns.sql
Extended Properties.sql		Extended Properties.sql
Find Index Fragmentation.sql		Find Index Fragmentation.sql
Find Modify Dates of Stored Procs.sql		Find Modify Dates of Stored Procs.sql
Find Most Expensive Queries.sql		Find Most Expensive Queries.sql
Find Orphan DB Users.sql		Find Orphan DB Users.sql
Find Partition Alignment (command prompt).sql		Find Partition Alignment (command prompt).sql
Find Ports SQL is listening to.sql		Find Ports SQL is listening to.sql
Find Tables without Clustered Indexes (New).sql		Find Tables without Clustered Indexes (New).sql
Find Tables without Clustered Indexes.sql		Find Tables without Clustered Indexes.sql
Find TempDB contention.sql		Find TempDB contention.sql
Find last queries you were working on.sql		Find last queries you were working on.sql
Find most used Procs and Functions.sql		Find most used Procs and Functions.sql
Find_Latest_Changes.sql		Find_Latest_Changes.sql
Foreign Key query.sql		Foreign Key query.sql
Foreign Keys.sql		Foreign Keys.sql
GRANT permissions for Profiler.sql		GRANT permissions for Profiler.sql
Get_All_PKs_and_FKs.sql		Get_All_PKs_and_FKs.sql
Get_Fragmentation_in_all_tables.sql		Get_Fragmentation_in_all_tables.sql
Get_all_Indexes.sql		Get_all_Indexes.sql
How Long DBCC CHECKDB will take.sql		How Long DBCC CHECKDB will take.sql
How Many Users Connect to DB.sql		How Many Users Connect to DB.sql
IO Stalls.sql		IO Stalls.sql
IO Statistics over a period of time.sql		IO Statistics over a period of time.sql
IO Utilization.sql		IO Utilization.sql
Implicite Column Conversions in Plan Cache.sql		Implicite Column Conversions in Plan Cache.sql
Index - Script out all indexes in database.sql		Index - Script out all indexes in database.sql
Index Counts.sql		Index Counts.sql
Index Fragmentation.sql		Index Fragmentation.sql
Index Optimize.sql		Index Optimize.sql
Index Usage Stats.sql		Index Usage Stats.sql
Last Time Database was accessed.sql		Last Time Database was accessed.sql
Latches - Top Latch types.sql		Latches - Top Latch types.sql
Lines of Code.sql		Lines of Code.sql
Linked Server - Check if DBCC SHOW_STATISTICS failes.sql		Linked Server - Check if DBCC SHOW_STATISTICS failes.sql
Linked Servers.sql		Linked Servers.sql
List columns where collation doesn't match database.sql		List columns where collation doesn't match database.sql
Logins - Script Logins.sql		Logins - Script Logins.sql
Memory Monitoring.sql		Memory Monitoring.sql
Memory per database.sql		Memory per database.sql
Missing Indexes (SQL Fool).sql		Missing Indexes (SQL Fool).sql
Missing Indexes Query.sql		Missing Indexes Query.sql
Open Transaction Count.sql		Open Transaction Count.sql
PAL_Setup_v2.3.3_x64.zip		PAL_Setup_v2.3.3_x64.zip
Page Life Expectancy.sql		Page Life Expectancy.sql
Perfmon - Quick Stats.sql		Perfmon - Quick Stats.sql

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Repository files navigation

SQLScripts

About

Uh oh!

Releases

Packages

Languages

sql3d/SQLScripts

Folders and files

Latest commit

History

Repository files navigation

SQLScripts

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages