Damian is Microsoft MVP and Certified Trainer with 20 years of experience. Now trying to share the passion and knowledge among others. He runs the blog with his daughter as she is really passionate about technology

Person Stirring Coffee with a Spoon

Weekly reading #21

Hello, hello! We have just started new week! We missed the weekly reading last time due to travelling across the Europe over the weekend. There is however a lot...

2019-07-15

28 reads

Weekly reading #20

Being MVP for the #11 straight year is something unique! Thank you! The first week of July has just started. So oficially we have started vacations and the team...

2019-07-01

12 reads

Coffee

Weekly reading #19

Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland. I do not know what temperature you have but here we are like in a...

2019-06-25

13 reads

Breakfast by the sea image

Weekly reading #18

Ready for vacations? The CodingFamily team is almost ready – we have some vacations plans including great conferences during summer and in the autumn. T-SQL bugs, pitfalls, and best...

2019-06-17

13 reads

Round Table of Coffee

Weekly reading #0x10

This is the blog anniversary! 16th Weekly reading has come into the light! For great articles and a video wait for you! Report Parameter Support for Paginated Report E-Mail...

2019-06-03

12 reads

Cup and Saucer

Weekly reading #15

SQLDay 2019 is gone. The Data Community.PL has now a new goal – it is the SQL Saturday #914 in Torun. The speakers will be announced after July 30th....

2019-05-27

18 reads

Blogs

Implement a RAG Solution Using Azure SQL Database

By

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

2024 PASS Data Community Summit Prep

By

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

A New Word: Bye-over

By

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

Read the latest Blogs

Forums

PASS Summit Time

By Louis Davidson (@drsql)

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

database restore chain

By sqlfriend

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

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