Upcoming Free Webinars on Database Development and Operations
Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar. Weekly Database DevOps Live Chats – a new experiment...
2019-11-19
1 reads
2019-11-16
3 reads
2019-11-16
7 reads
Links and Resources from “How to Architect Successful Database Changes”
Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a great group...
2019-11-06
15 reads
2019-11-06
1 reads
2019-11-06
4 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
3 reads
Project Management and Advocacy
I’ve observed few similarities between the Project Managers and Advocates. Being Project Manager, law bachelor and little practical experienced as an Advocate, I noticed few similarities. I think it’s...
2019-11-04
12 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
3 reads
Does it matter ?
A series of articles that will talk about most important but least focused areas in Database Design and Development.
2019-10-31
1 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
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.
Recently I received a cry for help over Teams. The issue was that an...
Forums
A Guide to SQL Security in Django
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
Comments posted to this topic are about the item I Need a CS Degree....
Incremental Statistics
Comments posted to this topic are about the item Incremental Statistics
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 = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers