Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Show Column/Result Set Information for a Store Procedure
SQL
3 months ago
mssql
storedprocedures
Perform Case Sensitive Comparisons in SQL Server
SQL
7 months ago
case-sensitive
collation
compare
mssql
search
List SQL Server Database Files and Backup Sizes
SQL
8 months ago
backup
cte
database
dba
mssql
size
Creating a Memory-Optimized Table and a Natively Compiled Stored Procedure
SQL
8 months ago
examples
in-memory
memory-optimized
mssql
storedprocedures
Enable In-Memory OLTP
SQL
8 months ago
dba
in-memory
memory-optimized
mssql
Drop Function if Exists
SQL
11 months ago
functions
mssql
udf
Create Column If Not Exists
SQL
11 months ago
column
exists
mssql
Trim Leading Zeros SQL Server Function
SQL
11 months 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
4 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
Show Table Names in SQL Server
SQL
5 years ago
catalog
database
dba
mssql
table
1
2
3
4
5
6
»
Last
More »