I recently set up Redgate’s SQL Change Automation in Visual Studio 2017, and I ran into a confusing error when I started trying to use it. For any other...
2018-10-03
3 reads
Every now and again, someone asks if I write romance novels. Why? Well, let’s ask Bing who Kendra Little is…. To clarify, I am not married, I have dogs...
2018-10-01
1 reads
I’ve submitted a session proposal to the free, online GroupBy conference. Voting will open for sessions soon, but before then, you can help me out by reading my abstract....
2018-09-27
I’ve got FOUR sessions coming up in October. These sessions will each be 30 minutes. Redgate Sessions Wed, Oct 3, 9AM PT / 12PM ET: How to Lead DBAs...
2018-09-26
It’s TSQL Tuesday today! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great...
2018-09-11
2 reads
Do you know where your career is going? Do you know what skills you need to be successful in the current climate? In this 25 minute keynote, I discuss the...
2018-09-07
SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired. Join us...
2018-09-03
2 reads
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
Sometimes it’s useful to know how to cause a problem. Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and...
2018-08-22
11 reads
SQL in the City is coming up, and it's a huge opportunity to learn. Register now to attend the free online streamed event, and join the Redgate team in...
2018-08-22
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
Hello everyone, I hope you can help me. I have a table with measurement...
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
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