A Script A Day - Day 7 - Memory Queries
Today's script is a collection of a few memory queries I've collected from various sources over the years. These queries are by no...
2012-02-07
2,334 reads
SQL Server 365
A Script A Day - Day 6 - Drop and Create Database Snapshots
Today's Script will drop all database snapshots and create a database snapshot for all online read writeable user databases. I...
2012-02-06
3,894 reads
A Script A Day - Day 5 - Database Owner Permissions
Today's script will list all principals with membership in the db_owner fixed database role.
/* ----------------------------------------------------------------- Database Owner Permissions ----------------------------------------------------------------- For more SQL resources, check...
2012-02-05
1,134 reads
A Script A Day - Day 4 - Estimated Time Left
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
488 reads
A Script A Day - Day 3 - Live Change Data Edit Template
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
568 reads
A Script A Day - Day 2 - Database Mail Troubleshooting
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
488 reads
A Script A Day - Day 1 - Database File To Volume Mapping
Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...
2012-02-01
582 reads
Database 101
I had an interesting phone call this morning from our professional services team. They are carrying out what I can...
2012-01-26
614 reads
Venting Frustration
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
596 reads
A Script a Day
In February I will be starting a series of Blog Posts I'm calling a "A Script a Day". Each day...
2012-01-24
621 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers