Skip to content

aherd2985/SQLsnippets

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

43 Commits
ADShortcuts
ADShortcuts
 
 
Azure_Backup to Azure Storage.sql
Azure_Backup to Azure Storage.sql
 
 
Azure_Create SAS and Restore dB.sql
Azure_Create SAS and Restore dB.sql
 
 
BollingerBand.sql
BollingerBand.sql
 
 
Constraint Names list.sql
Constraint Names list.sql
 
 
Create Nonclustered Index.sql
Create Nonclustered Index.sql
 
 
Create fn_WorkDays.sql
Create fn_WorkDays.sql
 
 
CreateBIdateDimensionTable.sql
CreateBIdateDimensionTable.sql
 
 
CursorExample.sql
CursorExample.sql
 
 
DenyTableDefinitions.sql
DenyTableDefinitions.sql
 
 
DropAllTables
DropAllTables
 
 
FailedSubscriptions.sql
FailedSubscriptions.sql
 
 
Find All Triggers and their associated Table.sql
Find All Triggers and their associated Table.sql
 
 
FindLockAndKill.sql
FindLockAndKill.sql
 
 
GRANT.sql
GRANT.sql
 
 
GrantExecute.sql
GrantExecute.sql
 
 
Identity_Off.sql
Identity_Off.sql
 
 
Lead_Lag.sql
Lead_Lag.sql
 
 
LoadHolidays.sql
LoadHolidays.sql
 
 
MergeUsingCTE.sql
MergeUsingCTE.sql
 
 
Modified_Objects.sql
Modified_Objects.sql
 
 
ObjectCreator.sql
ObjectCreator.sql
 
 
OperationPercentUntilDone.sql
OperationPercentUntilDone.sql
 
 
Pivot_Example.sql
Pivot_Example.sql
 
 
ProcedureLastModifiedDate.sql
ProcedureLastModifiedDate.sql
 
 
QueriesRanByUsers.sql
QueriesRanByUsers.sql
 
 
QueriesRanLastWeek.sql
QueriesRanLastWeek.sql
 
 
README.md
README.md
 
 
RankPartition
RankPartition
 
 
RecursiveCTE.sql
RecursiveCTE.sql
 
 
SP Logic from other Server.sql
SP Logic from other Server.sql
 
 
SQL_Column_Search.sql
SQL_Column_Search.sql
 
 
SQL_Last_Queries.sql
SQL_Last_Queries.sql
 
 
SQL_Server_Analysis_Query.sql
SQL_Server_Analysis_Query.sql
 
 
SSRS Detail.sql
SSRS Detail.sql
 
 
SSRS Subscriber broken out.sql
SSRS Subscriber broken out.sql
 
 
SSRS_Datasets.sql
SSRS_Datasets.sql
 
 
SSRS_Subscriptions FUN.sql
SSRS_Subscriptions FUN.sql
 
 
SSRSsubscriptionFails.sql
SSRSsubscriptionFails.sql
 
 
SearchNonNullColumns.sql
SearchNonNullColumns.sql
 
 
SearchTaskAgentScripts.sql
SearchTaskAgentScripts.sql
 
 
Search_SSRS_Queries.sql
Search_SSRS_Queries.sql
 
 
Search_SSRS_Subscriptions_Recieptents.sql
Search_SSRS_Subscriptions_Recieptents.sql
 
 
Search_Stored_Procedures.sql
Search_Stored_Procedures.sql
 
 
SearchdB4Text.sql
SearchdB4Text.sql
 
 
SearchdB4Value.sql
SearchdB4Value.sql
 
 
SendEmail.sql
SendEmail.sql
 
 
SetupCoreMembership.sql
SetupCoreMembership.sql
 
 
ShrinkFile.sql
ShrinkFile.sql
 
 
SingleUserMode.sql
SingleUserMode.sql
 
 
Stored Procedure run times stats .sql
Stored Procedure run times stats .sql
 
 
Stored Procedure text search .sql
Stored Procedure text search .sql
 
 
Stuff Example.sql
Stuff Example.sql
 
 
TableDetails
TableDetails
 
 
Task Agent job last execution status .sql
Task Agent job last execution status .sql
 
 
TaskAgentJobAudit.sql
TaskAgentJobAudit.sql
 
 
TaskAgentJobSchedule.sql
TaskAgentJobSchedule.sql
 
 
TransactionTryCatch.sql
TransactionTryCatch.sql
 
 
Trigger.sql
Trigger.sql
 
 
Update_from_CTE.sql
Update_from_CTE.sql
 
 
WhatDidTheyDo.sql
WhatDidTheyDo.sql
 
 
gitRemove.sh
gitRemove.sh
 
 
hostname.txt
hostname.txt
 
 

Repository files navigation

SQLsnippets

SQL I commonly reference

Feel free to add any useful SQL scripts!

Crypto Tip Jar

Donate with Crypto

Thank you!

About

SQL I commonly reference

Topics

sql dba

Resources

Readme
Activity

Stars

3 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages