Maybe the most efficient way to mockup 100 million rows of randomized test data would be to leverage PowerShell or Python to create text files and then BCP them...

• This reply was modified 2 years, 5 months ago by Jeff Moden.

On a personal note, I just don't understand companies that post a webinar and, to register, they REQUIRE you have to provide your phone number and, frequently, a...

Here is another way.

If you do something like this in PoSh, to create a delimited text file, it is then very easy to import the results in tabular form.

@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.