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,343 reads
Chris McGowan
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,906 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,138 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
493 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
573 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
494 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
587 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
619 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
601 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
625 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers