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,313 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,871 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,124 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
478 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
559 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
478 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
568 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
606 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
587 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
616 reads
Blogs
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Using SQL Compare to Revert a Stored Procedure
By Steve Jones
Imagine this situation, someone edits a stored procedure on a production server to “fix”...
PASS Data Community Summit LinkedIn Contest
By Brian Kelley
If you're not having success in convincing your organization to send you to this...
Forums
CDC job running for 17 days?
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
Database growth events for unidentified databases
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
distributed availability group query
Not sure if this is my misunderstanding or an error in my process: Create...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers