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

Repository files navigation

SQLScripts

About

Uh oh!

Releases

Packages

Languages

Search code, repositories, users, issues, pull requests...

sql3d/SQLScripts

Folders and files

Latest commit

History

Repository files navigation

SQLScripts

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages