Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
MySQL Fuzzy Text Searching
SQL
9 years ago
fuzzy
mysql
search
soundex
udf
Test a SQL Query Before Committing
SQL
9 years ago
commit
examples
mssql
rollback
testing
transaction
Create User-defined Functions and Stored Procedures in MySQL
SQL
9 years ago
examples
mysql
storedprocedures
udf
Insert Results of Stored Procedure into Temp Table
SQL
9 years ago
examples
mssql
query
storedprocedures
table
temp
Create or Delete Temp Table If Exists
SQL
9 years ago
dba
examples
mssql
query
table
temp
Count Rows in All Tables
SQL
9 years ago
calculations
count
dba
mssql
rows
table
total
Determine Size of a Table in SQL Server
SQL
9 years ago
calculations
dba
index
mssql
size
space
sp_msforeachtable
storage
table
Find Duplicate Entries in MySQL
SQL
9 years ago
dupe
examples
fuzzy
mysql
search
soundex
Parent-Child Table Dependency Script
SQL
9 years ago
dba
dependency
foreignkey
mssql
table
Copy SSIS Variables to New Environments
SQL
9 years ago
dba
environment
mssql
ssis
variable
Is Daylight Savings Time SQL Function
SQL
9 years ago
date
datetime
mssql
timezone
udf
Provision Windows Domain Account in SQL Server
SQL
9 years ago
account
activedirectory
examples
mssql
provision
role
security
New Drop If Exists Syntax in SQL Server 2016
SQL
10 years ago
dba
drop
examples
mssql
SQL Server CPU Pressure
SQL
10 years ago
cpu
dba
diagnostics
mssql
Get Non-Default SQL Server Configurations
SQL
10 years ago
configuration
dba
mssql
Drop Table Column in SQL Server
SQL
10 years ago
column
dba
examples
mssql
schema
table
Syntax for sp_msforeachtable and sp_msforeachdb
SQL
10 years ago
database
dba
examples
mssql
sp_msforeachdb
sp_msforeachtable
table
Delete All Records from All Tables in Database
SQL
10 years ago
dba
delete
mssql
sp_msforeachtable
table
Empty Transaction Log File
SQL
10 years ago
dba
log
maintenance
mssql
Disable/Enable All Constraints and Triggers
SQL
10 years ago
constraint
dba
mssql
sp_msforeachtable
trigger
«
1
2
3
4
5
6
7
8
9
»
Last
More »