Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
PostgreSQL Performance Monitoring Queries
SQL
4 days ago
dba
postgresql
Show Column/Result Set Information for a Store Procedure
SQL
5 months ago
mssql
storedprocedures
Perform Case Sensitive Comparisons in SQL Server
SQL
10 months ago
case-sensitive
collation
compare
mssql
search
List SQL Server Database Files and Backup Sizes
SQL
10 months ago
backup
cte
database
dba
mssql
size
Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure
SQL
11 months ago
examples
in-memory
memory-optimized
mssql
storedprocedures
Enable In-Memory OLTP
SQL
11 months ago
dba
in-memory
memory-optimized
mssql
Drop Function if Exists
SQL
1 year ago
functions
mssql
udf
Create Column If Not Exists
SQL
1 year ago
column
exists
mssql
Trim Leading Zeros SQL Server Function
SQL
1 year ago
functions
mssql
trim
udf
SQL Server Maintenance Solution
SQL
1 year ago
dba
maintenance
mssql
Check if Date Occurs on Day of Week
SQL
3 years ago
date
datetime
day
functions
mssql
udf
utils
Determine Day of Week in SQL Server
SQL
3 years ago
date
day
functions
mssql
udf
Output the Results of a SQL Server Merge Statement
SQL
4 years ago
debug
examples
merge
mssql
Collapse Whitespace SQL Server Function
SQL
4 years ago
collapse
mssql
string
trim
udf
whitespace
Strip HTML Tags SQL Server Function
SQL
4 years ago
html
mssql
strip
tags
udf
Decode HTML SQL Server Function
SQL
4 years ago
decode
encode
functions
html
html-decode
mssql
udf
Trim and Uppercase String if not Null
SQL
4 years ago
mssql
string
trim
udf
uppercase
SQL Server Functions to Strip Unwanted Characters
SQL
5 years ago
alpha
alphanumeric
character
functions
mssql
number
strip
udf
Capture SQL Server Execution Timings
SQL
5 years ago
benchmark
mssql
performance
query
sql
SQL Server Database Performance Analysis Script
SQL
5 years ago
analysis
dba
mssql
performance
storedprocedures
1
2
3
4
5
6
»
Last
More »