Basic PowerShell: Get-Member
Disclaimer: I’m still learning PowerShell. I’ve been using it more lately and I want to talk about it more. I’ll...
2019-01-08
224 reads
Arthur's Blog
Query plan hash
This is post 3 in the series about query fingerprints. Here’s the previous posts in this series:
Query HashSQL Handle
What is...
2019-01-07
650 reads
One tip for presenting: have a conversation
I like public speaking, but I haven’t always liked it. It started when I read Dale Carnegie’s book on public...
2019-01-05
34 reads
Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
179 reads
Query Store max size limit is not a hard limit
If you’re on SQL Server 2016 or above, maybe you’re thinking about using the Query Store. That’s good! It’s an...
2019-01-03
1,355 reads
Make sure your nonclustered indexes are enabled
I know this post might sound obvious. This is a very rare problem. But this actually happened to me, and...
2019-01-02
39 reads
Blogs
Understanding Zonal Redundancy in Azure SQL MI
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
SQL Server Database Compatibility Levels
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
The PASS Summit on Tour in the Netherlands
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Upgraded VS2019 to version 16.11.49 but I cannot access my original SSIS package
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
How do I make this one row per id
I've written this code, but it is showing right now as 2 rows per...
Question of the Day
The Updated Columns List
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