The fourth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with numeric conversions.

Blogs

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...

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...

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?