All authors

All authors

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

The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.

By

Recently I received a cry for help over Teams. The issue was that an...

Read the latest Blogs

Forums

Python with SQL 2022 Enterprise doesn’t work

By VK_Carry

I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...

A Guide to SQL Security in Django

By omu

Comments posted to this topic are about the item A Guide to SQL Security...

I Need a CS Degree. I Don't Need a CS Degree

By Steve Jones - SSC Editor

Comments posted to this topic are about the item I Need a CS Degree....

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