Skip to main content
snippets
S
nippets
SQL
Snippets
Date
•
Title
Check if Index Exists in SQL Server
SQL
6 years ago
dba
exists
index
mssql
table
Using Dynamic SQL in Stored Procedures
SQL
6 years ago
dynamic
examples
mssql
security
sqlinjection
storedprocedures
Copy a SQL Server Database to Another Environment
SQL
6 years ago
backup
copy
dba
environment
mssql
Backup User Databases in SQL Server
SQL
6 years ago
backup
dba
mssql
Shrink All Database Files in SQL Server
SQL
6 years ago
dba
mssql
shrink
Truncate All Transaction Logs in SQL Server
SQL
6 years ago
dba
log
mssql
transaction
Disable SQL Server Agent Jobs in Category
SQL
6 years ago
dba
disable
job
mssql
sp_update_job
sqlserveragent
Find Out Who Deleted Rows in SQL Server
SQL
6 years ago
audit
dba
delete
mssql
Get Epoch Time in SQL Server
SQL
6 years ago
date
datetime
epoch
mssql
time
timestamp
Get Time Zone Information in SQL Server
SQL
6 years ago
datetime
mssql
timezone
utc
sp_whoisactive SQL Server Monitoring Stored Procedure
SQL
6 years ago
dba
mssql
performance
sp_whoisactive
storedprocedures
Automatically Run Stored Procedure at Startup
SQL
6 years ago
dba
mssql
sp_procoption
startup
storedprocedures
Using Multiple CTEs in a Single Statement
SQL
6 years ago
count
cte
examples
mssql
Enable Transparent Data Encryption in SQL Server
SQL
6 years ago
dba
encryption
examples
mssql
tde
Performance Impact of Using SELECT *
SQL
6 years ago
bestpractices
examples
mssql
performance
select
Backup and Restore an Existing Database to a new Database
SQL
6 years ago
backup
dba
mssql
restore
Different Pagination Methods in SQL Server
SQL
6 years ago
mssql
pagination
storedprocedures
Handling Errors in SQL Server 2012
SQL
6 years ago
examples
exception
mssql
storedprocedures
template
throw
Generate Random Numbers in SQL Server
SQL
6 years ago
examples
mssql
number
random
List All SQL CLR Assemblies and Database Objects
SQL
7 years ago
dba
mssql
sqlclr
«
1
2
3
4
5
6
7
»
Last
More »