Upcoming full day training: “How to Architect Successful Database Changes”
I’m excited to be teaching a full day session with Steve Jones at the SQL PASS Summit on Tuesday, November 5, in Seattle. Steve and I will be discussing...
2019-04-19
1 reads
Take the 2019 State of SQL Server Monitoring Survey: Here’s What’s in It For You
Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers. Take the survey before April 5, 2019. Your...
2019-03-19
2 reads
The SQL Server Data Row Size Question: Why is It Bigger?
This morning, I received the following question from a user: Hello Madam, Could you please clarify SQLServer “Data Row” size: If I run the script below on SQL Server...
2019-03-19
1 reads
Why to Avoid Using the Current Database Name in Object Definitions in SQL Server
I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. In the article, I discuss:...
2019-03-18
1 reads
PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas
Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three...
2019-03-13
1 reads
Contest: Tell Your Database Development Disaster Story (5 winners get $150 USD or more each)
Redgate is building a library of real-world stories about database development disasters. Your mission: Tell us a true story in 500 words or less about a time when you...
2019-03-12
Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)
I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...
2019-03-04
4 reads
New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and...
2019-02-15
1 reads
What a Software Evangelist Does – and Where the Job is Going (Dear SQL DBA Episode 67)
I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software...
2019-01-29
3 reads
State vs Migration for Database Source Control – decide based on one question
One controversial topic in database development is how to properly store and deploy database changes. This is generally described as choosing between two options, which are approximately as easy...
2019-01-23
3 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
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
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....
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