@Brian,

It's not as rare as you might think in production code if you use TempDB or a "scratch/working" database to get "balls-out" ( https://en.wiktionary.org/wiki/balls-out ) performance in code, especially when...

Thank you for the feedback, Lisa.  You're absolutely correct about the labels and fervor and, especially, the changes from what I believe the original intent was for a whole lot...

I don't and haven't used any of this sort of thing.  "Bumping" this for you and, because I'm interested, for me as well.

I've been wondering what chances DevOps has in an organization which doesn't want to adopt DevOps. I work at a place where resistance to DevOps is predominant. Because this...

The error is telling me that you have a table that might be in a little trouble and some column widths need to be adjusted either for width or maybe...

If you know how to use xp_CmdShell properly and safely, here's how I do such things.  Since you're not using SQL Server 2022, the STRING_SPLIT() function isn't guaranteed by MS...

Today I found out what a SQL Inline Table Value Function is!

I can't understand how an iTVF would be easier to use, I have a calculation like s0:

            
September 16, 2023 at 9:36 pm
            
#4287958

            
            
                                                
        

Another thing to add to your list is a nightly file usage check. That should also include a "Page Density" check on your indexes and heaps.  Your infrastructure guys should...

@jeff, while I agree with you about the most important goal, I don't think Steve meant "daily" when he said "everyday".  He meant "quotidien/mundane/matter-of-fact/run-of-the-mill/as-expected".  And no, I'm not checking...

Hey Jeff,

I was talking to Bob Ward about your tests. He was interested in an introduction to talk about them. Any interest? If so, which email should...

  Thanks for the feedback.

It's still a scalar function and your retry explains why this thread took so long and died.

From the Article:

The goal is repeatable, reliable software deployments, with releases, or at least deployments, being an everyday occurrence, not a big event.

I have to strongly disagree... the goal is...

@Grasshopper's solution does not work for negative numbers, so here's his version that does work for negative numbers:

create function dbo.RoundToEven(@num numeric(38,19)) returns decimal(19,2)
begin
return case
  ...

Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results...