Having just successfully built a functional application using only prompts and agentic AI, dbRosetta if anyone is interested, I have to say, currently, this thing isn't going to replace...

Q1) You can. I wouldn't because, for most people, this thing is back there running and they never know. It's the hyper-rare workload that will see actual interference from this....

Yeah, I'd still separate them. Same underlying issues are still there. Different levels and types of IO for each mechanism. Splitting them even lets you pick different levels of IOPs...

Since you are updating manually, I'd break it down a lot more. And, probably run it more often. The key is, how many changes to the data leads to performance...

The bad news, there's no magic formula anyone can provide to give you a perfect answer. You're going to need to experiment with this to figure things out. Sorry.

First things...

Nice to hear it. The hallway track is real. And really helpful.

It's a big month for me.  After 21 years, I'm being made redundant on the 28th when we finally hand over our contract to another company.  I started at...

Just to follow on a little bit.

Columnstore helps with analytical queries. GROUP BY, COUNT, stuff like that which traditional rowstore never handled well. Simply scanning the entire table won't be...

I can't see anything.

Sorry I haven't been here to respond to you all. I've been traveling quite a bit (typing this in Hong Kong of all places).

What you all say resonates. @EdVassie, yeah,...

Thanks for the feedback Mandeep. Keep up the good work.

Nope! Having too much fun.

Thanks all for the feedback.

For some reason (I'll take the blame, but I don't know what I did) I'm not receiving emails on stuff I'm subscribed to. Weirdness. Working on...

The example from SQLShack is good. Here's the Microsoft documentation on it. You 100% can use it with your linked servers. You just have to code it. Follow the...

Extended Events can't do things. They're monitoring. They observe things. You could code something that sends an email in response to an Extended Event, absolutely. However, the Extended Event is...

• This reply was modified 4 months, 2 weeks ago by Grant Fritchey.