Blogs

AI and ChatGPT are all the rage these days. Seems like around every corner...

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...

bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...

Forums

Comments posted to this topic are about the item PASS Summit Time

I have a backup of full, differential and transaction log setup for our database....

Hello everyone, I hope you can help me. I have a table with measurement...

I have run this on SQL Server 2022 for the Sales database:

ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)

I then run this in the Sales database:

USE Sales
GO
CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFF

The dbo.Customer table is partitioned. How are statistics created?