Skip to content

Latest commit

 

History

History
 
 

Stored_Procedure

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
Recover_Deleted_Data_Proc.sql
Recover_Deleted_Data_Proc.sql
 
 
dbo.PerformanceGraph.sql
dbo.PerformanceGraph.sql
 
 
dbo.sp_AllocationMetadata.sql
dbo.sp_AllocationMetadata.sql
 
 
dbo.sp_BenchmarkTSQL.sql
dbo.sp_BenchmarkTSQL.sql
 
 
dbo.sp_BlitzInMemoryOLTP.sql
dbo.sp_BlitzInMemoryOLTP.sql
 
 
dbo.sp_Blocked_Process_Report_Viewer.sql
dbo.sp_Blocked_Process_Report_Viewer.sql
 
 
dbo.sp_ChangeDatabaseOwnerShip.sql
dbo.sp_ChangeDatabaseOwnerShip.sql
 
 
dbo.sp_DBA_job_notification.sql
dbo.sp_DBA_job_notification.sql
 
 
dbo.sp_Defrag_Indexes.sql
dbo.sp_Defrag_Indexes.sql
 
 
dbo.sp_Depends.sql
dbo.sp_Depends.sql
 
 
dbo.sp_DropIndexes.sql
dbo.sp_DropIndexes.sql
 
 
dbo.sp_Example_RegisterAssembly_PDFCLR.sql
dbo.sp_Example_RegisterAssembly_PDFCLR.sql
 
 
dbo.sp_FailedJobs.sql
dbo.sp_FailedJobs.sql
 
 
dbo.sp_FailedLogins.sql
dbo.sp_FailedLogins.sql
 
 
dbo.sp_GenerateMerge.sql
dbo.sp_GenerateMerge.sql
 
 
dbo.sp_IndexAnalysis-v11.sql
dbo.sp_IndexAnalysis-v11.sql
 
 
dbo.sp_PerfSQ.sql
dbo.sp_PerfSQ.sql
 
 
dbo.sp_PrintString.sql
dbo.sp_PrintString.sql
 
 
dbo.sp_RestoreGene.sql
dbo.sp_RestoreGene.sql
 
 
dbo.sp_RestoreScript.sql
dbo.sp_RestoreScript.sql
 
 
dbo.sp_SQLskills_ExposeColsInIndexLevels.sql
dbo.sp_SQLskills_ExposeColsInIndexLevels.sql
 
 
dbo.sp_SQLskills_helpindex.sql
dbo.sp_SQLskills_helpindex.sql
 
 
dbo.sp_Snapshot.sql
dbo.sp_Snapshot.sql
 
 
dbo.sp_WhatsupQueryStore.sql
dbo.sp_WhatsupQueryStore.sql
 
 
dbo.sp_capture_login_auth.sql
dbo.sp_capture_login_auth.sql
 
 
dbo.sp_ctrl3.sql
dbo.sp_ctrl3.sql
 
 
dbo.sp_doc.sql
dbo.sp_doc.sql
 
 
dbo.sp_estindex.sql
dbo.sp_estindex.sql
 
 
dbo.sp_foreign_key$batch_drop_and_recreate.sql
dbo.sp_foreign_key$batch_drop_and_recreate.sql
 
 
dbo.sp_generate_merge.sql
dbo.sp_generate_merge.sql
 
 
dbo.sp_helpExpandView.sql
dbo.sp_helpExpandView.sql
 
 
dbo.sp_help_permissions.sql
dbo.sp_help_permissions.sql
 
 
dbo.sp_helpme.sql
dbo.sp_helpme.sql
 
 
dbo.sp_ns_shrink_db_log.sql
dbo.sp_ns_shrink_db_log.sql
 
 
dbo.sp_sizeoptimiser.sql
dbo.sp_sizeoptimiser.sql
 
 
dbo.sp_sizing.sql
dbo.sp_sizing.sql
 
 
dbo.sp_sqltrace.sql
dbo.sp_sqltrace.sql
 
 
dbo.sqlg_ParseDiskskpXml.sql
dbo.sqlg_ParseDiskskpXml.sql
 
 
dbo.udp_IntegerListfromRanges.sql
dbo.udp_IntegerListfromRanges.sql
 
 
dbo.usp_Breadth_First.sql
dbo.usp_Breadth_First.sql
 
 
dbo.usp_BulkUpload.sql
dbo.usp_BulkUpload.sql
 
 
dbo.usp_CopyLogins.sql
dbo.usp_CopyLogins.sql
 
 
dbo.usp_CreatePlantUMLCode.sql
dbo.usp_CreatePlantUMLCode.sql
 
 
dbo.usp_DBA_Rename_Database.sql
dbo.usp_DBA_Rename_Database.sql
 
 
dbo.usp_Dijkstra.sql
dbo.usp_Dijkstra.sql
 
 
dbo.usp_EnableAndAddFileStreamForDatabase.sql
dbo.usp_EnableAndAddFileStreamForDatabase.sql
 
 
dbo.usp_FindDbObjects.sql
dbo.usp_FindDbObjects.sql
 
 
dbo.usp_GenerateRandomPassword.sql
dbo.usp_GenerateRandomPassword.sql
 
 
dbo.usp_Generate_Merge.sql
dbo.usp_Generate_Merge.sql
 
 
dbo.usp_GetPackageDetails.sql
dbo.usp_GetPackageDetails.sql
 
 
dbo.usp_GetUntrustedForeignKeys.sql
dbo.usp_GetUntrustedForeignKeys.sql
 
 
dbo.usp_Kruskal.sql
dbo.usp_Kruskal.sql
 
 
dbo.usp_LoadTableBlobs.sql
dbo.usp_LoadTableBlobs.sql
 
 
dbo.usp_LogError.sql
dbo.usp_LogError.sql
 
 
dbo.usp_Object_Search.sql
dbo.usp_Object_Search.sql
 
 
dbo.usp_Prim.sql
dbo.usp_Prim.sql
 
 
dbo.usp_PrintDebug.sql
dbo.usp_PrintDebug.sql
 
 
dbo.usp_PrintError.sql
dbo.usp_PrintError.sql
 
 
dbo.usp_RandomWait.sql
dbo.usp_RandomWait.sql
 
 
dbo.usp_RunCheckAllUntrustedForeignKeys.sql
dbo.usp_RunCheckAllUntrustedForeignKeys.sql
 
 
dbo.usp_SQL_Server_System_Report.sql
dbo.usp_SQL_Server_System_Report.sql
 
 
dbo.usp_SQLskillsAnalyzeLog.sql
dbo.usp_SQLskillsAnalyzeLog.sql
 
 
dbo.usp_SSIS_ScriptEnvironment.sql
dbo.usp_SSIS_ScriptEnvironment.sql
 
 
dbo.usp_SearchOnAllDB.sql
dbo.usp_SearchOnAllDB.sql
 
 
dbo.usp_SearchStoredProcedureText.sql
dbo.usp_SearchStoredProcedureText.sql
 
 
dbo.usp_SetFileGrowth.sql
dbo.usp_SetFileGrowth.sql
 
 
dbo.usp_String_Search.sql
dbo.usp_String_Search.sql
 
 
dbo.usp_TableUnpivot.sql
dbo.usp_TableUnpivot.sql
 
 
dbo.usp_TopologicalSort.sql
dbo.usp_TopologicalSort.sql
 
 
dbo.usp_TransliterationEN2RU.sql
dbo.usp_TransliterationEN2RU.sql
 
 
dbo.usp_UnusedInputParameters.sql
dbo.usp_UnusedInputParameters.sql
 
 
dbo.usp_bcpTableUnload.sql
dbo.usp_bcpTableUnload.sql
 
 
dbo.usp_bcpTableUnloadBatchMode.sql
dbo.usp_bcpTableUnloadBatchMode.sql
 
 
dbo.usp_bcpUnloadSelect.sql
dbo.usp_bcpUnloadSelect.sql
 
 
dbo.usp_checkAllDatabases.sql
dbo.usp_checkAllDatabases.sql
 
 
dbo.usp_generateIdentifier.sql
dbo.usp_generateIdentifier.sql
 
 
dbo.usp_who5.sql
dbo.usp_who5.sql
 
 

README.md

Microsoft SQL Server Stored Procedure

SQL Server Name Convention and T-SQL Programming Style

Start all procedure from if exist statement:

IF OBJECT_ID('dbo.ProcedureName', 'P') IS NULL
EXECUTE ('CREATE PROCEDURE dbo.ProcedureName AS SELECT 1');
GO


ALTER PROCEDURE dbo.usp_ProcedureName(

It helps to save all grants for procedure (analog CREATE OR REPLACE PROCEDURE in Oracle).

sp_IndexAnalysis-v11

Author: Jason Strate
Original link: http://www.jasonstrate.com/2013/05/index-analysis-may-update/
Tested on SQL Server version: 2012/2014

sp_RestoreGene

Author: Andy Yun
Original link: https://sqlbek.wordpress.com/2015/03/04/sp_helpexpandview-well-i-didnt-expect-that/
Tested on SQL Server version: 2008/2012/2014

sp_RestoreGene

Author: Paul Brewer
Original link: https://paulbrewer.wordpress.com/sp_restoregene/
Tested on SQL Server version: 2008/2012/2014

usp_GetUntrustedForeignKeys

Author: Jefferson Elias
Original link: http://www.sqlshack.com/managing-untrusted-foreign-keys/
Tested on SQL Server version: 2008/2012/2014

usp_RunCheckAllUntrustedForeignKeys

Author: Jefferson Elias
Original link: http://www.sqlshack.com/managing-untrusted-foreign-keys/
Tested on SQL Server version: 2008/2012/2014

sp_capture_login_auth

Author: Unknown
Original link: Unknown
Tested on SQL Server version: 2012/2014

sp_Blocked_Process_Report_Viewer

Author: Michael J. Swart
Original link: https://sqlblockedprocesses.codeplex.com/
Tested on SQL Server version: 2012/2014

sp_sqltrace

Author: Erland Sommarskog
Original link: http://www.sommarskog.se/sqlutil/sqltrace.html
Tested on SQL Server version: 2005/2008/2012/2014

usp_BulkUpload

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_EnableAndAddFileStreamForDatabase

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012

usp_FindDbObjects

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_LogError

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_Object_Search

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

usp_PrintDebug

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_PrintError

Author: Microsoft
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_RandomWait

Author: Unknown
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_SQL_Server_System_Report

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

usp_SearchOnAllDB

Author: David Musgrave
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_String_Search

Author: Sean Smith
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_TableUnpivot

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_UnusedInputParameters

Author: Sean Smith
Original link: None
Tested on SQL Server version: 2008/2012/2014

usp_bcpTableUnload

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_bcpTableUnloadBatchMode

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_bcpUnloadSelect

Author: Konstantin Taranov
Original link: None
Tested on SQL Server version: 2012/2014

usp_who5

Author: Sean Smith
Original link: http://wwwservercentral.com/scripts/sp_who/68607/
Tested on SQL Server version: 2012/2014

usp_PrintString

Author: John Huang
Original link: http://www.sqlservercentral.com/blogs/john-huangs-blog/2015/11/19/print-long-string/
Tested on SQL Server version: 2014

usp_Generate_Merge

Author: Narayana Vyas Kondreddi
Original link: https://github.com/SQLauto/generate-sql-merge/blob/master/master.dbo.sp_generate_merge.sql
Tested on SQL Server version: 2008/2012/2014

usp_Generate_Merge

Author: Jeff Jordan
Original link: http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/135173/
Tested on SQL Server version: 2012/2014

usp_SQLskillsAnalyzeLog

Author: Paul S. Randal
Original link: http://www.sqlskills.com/blogs/paul/code-to-analyze-the-transaction-hierarchy-in-the-log/
Tested on SQL Server version: 2012/2014

usp_CreatePlantUMLCode

Author: Phil Factor
Original link: https://www.simple-talk.com/sql/sql-tools/automatically-creating-uml-database-diagrams-for-sql-server/
Tested on SQL Server version: 2012/2014