Partitioning 5: The extra partition
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
151 reads
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
151 reads
Happy Friday! Today’s post will be light on the performance side and instead, I’m going to talk about how to...
2019-02-15
1,442 reads
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,838 reads
In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.
Adding the partitioning...
2019-02-13
1,519 reads
This month’s T-SQL Tuesday is hosted by Andy Leonard at andyleonard.blog . Andy asks us, what is your “Why?”
So what is...
2019-02-12
678 reads
Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...
2019-02-27 (first published: 2019-02-11)
2,443 reads
I apologize in advance if I mess up the terminology.
I’ve worked with a moderate read workload on a readable replica...
2019-02-08
768 reads
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
809 reads
At first, this statement might sound a bit confusing. Usually, we expect wait statistics to show us what a query...
2019-02-06
210 reads
We occasionally get cool improvements in T-SQL in newer versions of SQL Server. Here’s a short post on some of...
2019-02-05
177 reads
By Arun Sirpal
Do you know what happens when you enable zonal redundancy for your SQL managed...
By Kevin3NF
Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting If you’ve...
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hi I upgraded to new version of VS2019 to 16.11.49. My original SSIS package...
I've written this code, but it is showing right now as 2 rows per...
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