Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Get SQL Server Listening Ports
SQL
9 years ago
dba
mssql
port
tcp
Get SQL Server Time Zone
SQL
9 years ago
dba
mssql
timezone
View for SQL Agent Job Histories
SQL
9 years ago
dba
mssql
sqlserveragent
ssis
view
Reseed Table Identity Value
SQL
9 years ago
database
dba
delete
identity
mssql
reseed
rows
table
truncate
Get SQL Server CLR Details
SQL
9 years ago
dba
mssql
sqlclr
UDF to Check for SQL Injection
SQL
9 years ago
mssql
security
sqlinjection
udf
Get SQL Server Error Numbers and Messages
SQL
9 years ago
dba
error
mssql
Paging Through A Result Set
SQL
9 years ago
examples
mssql
pagination
Get Logged-in User Session Details
SQL
9 years ago
cursor
dba
mssql
session
Show SQL Server Error Log Entries
SQL
9 years ago
dba
error
log
mssql
Normalize and Rename Database Constraints
SQL
9 years ago
constraint
database
dba
mssql
normalize
rename
Get File Size and Log Usage for all Databases
SQL
9 years ago
dba
log
mssql
size
Get Database Table IO Ratios
SQL
9 years ago
dba
io
mssql
performance
ratio
statistics
Show Failed and Successful Login Attempts
SQL
9 years ago
audit
dba
login
mssql
Get SQL Server Version
SQL
9 years ago
dba
details
mssql
os
server
version
Check if SQL Command Mode is Enabled
SQL
9 years ago
dba
mssql
sqlcmd
Remove Non-Alpha Characters from String
SQL
9 years ago
alpha
character
loop
mssql
remove
string
Show Active Connections
SQL
9 years ago
connection
dba
mssql
Change SQL Database Recovery Model to Simple
SQL
9 years ago
database
dba
mssql
recovery
SQL Server Split String Function
SQL
9 years ago
functions
list
mssql
split
sql
string
udf
«
1
2
3
4
5
6
7
8
9
10
11
»
Last
More »