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,310 reads
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,310 reads
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,870 reads
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
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
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
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
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
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
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
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
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
Comments posted to this topic are about the item How a Legacy Logic Choked...
The problem was reported to us by a customer. They shared a graphic execution...
I have 2 tables: TBL_A and TBL_B each with the same 2 columns; ServerName...
I have this table in SQL Server 2022:
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) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers