It doesn't because this isn't two inserts. It's a TVC (Values) that materializes first, and then when the insert happens, the TVC has already set the data type.

One more thought. If you want to have a good relationship with your kids, you need to spend time with them and engage. Not tell them what to do or...

I think you can create good culture, but you have to do it from the beginning. A few companies have done it well. Basecamp, a few others, but it's not...

I'm torn. I've worked in cubes, open offices, private offices. I think a mix of spaces is good. I do like the Redgate offices overall in Cambridge, with open desk...

You are welcome. Hope that helped.

Here's the script from Ola's site: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Does have compression in it. He has to update them here, which is a lagging task. I'll see if I can get him...

First, it's helpful to give some sample data and DDL  that helps understand this.

Second, here's a repro below. What's likely happened is there is some unprintable character that is getting...

A lot of people get it wrong. Or they choose not to work on getting it right, which brings that bill.

I've had a few people look to move some things...

That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.

However, if you want to try and post the steps with results...

That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.

However, if you want to try and post the steps with results...

That's strange. My sysadmin worked fine. I suspect you might not have reverted after setuser. That often causes issues.

However, if you want to try and post the steps with results...

I use Claude (from Redgate), but I am careful. I tend to stick with Sonnet for most things, only jumping to Opus if I need to, or coming back to...

Be thoughtful, be careful, be deliberate.

Analysis should include all of these, ending with a decision you've made (to do, or not to do something), not deferring things.

I find a lot...

I've missed lots of people from the past, and some I still keep in touch with.

I'm hoping to see Annabel again in Aug, or on a future trip.