Blogs

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

By

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

Counting Groups with Window Functions: #SQLNewBlogger

By

I looked at row_number() in a previous post. Now I want to build on...

Read the latest Blogs

Forums

WhatsApp +52 6643030891 Get A1, B1, C2 telc zertifikat without exam

By jacy1702

geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...

Get TELC Zertifikat B2 Without Exam in * Slovenia WhatsApp +52 6643030891

By jacy1702

geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...

Temporary Table Problem

By fk.da

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

Visit the forum

Question of the Day

Incremental Statistics

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?

See possible answers