Skip to content

Scripts

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History
 
 

Scripts

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Count character matches.sql
Count character matches.sql
 
 
Date Calendar Cross-Reference Table.sql
Date Calendar Cross-Reference Table.sql
 
 
Enable Microsoft.ACE.OLEDB.12.0.sql
Enable Microsoft.ACE.OLEDB.12.0.sql
 
 
Foreign Key batch rename.sql
Foreign Key batch rename.sql
 
 
README.md
README.md
 
 
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
 
 
Space used by object.sql
Space used by object.sql
 
 
Table Count alternative.sql
Table Count alternative.sql
 
 
Truncate log file.sql
Truncate log file.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-december-2015/
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-december-2015/
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-december-2015/
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-march-2015/
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-march-2015/
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-march-2015/
Tested on SQL Server version: 2005

[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