Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 59,091 total)

Reply To: Interview Questions for Advanced DB Engineer Candidates

With the understanding that this is nothing against you, if we posted such questions and the answers here, that would eventually render them useless in interviews because people will do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 20, 2023 at 4:18 am

#4290023
Reply To: GENERATE_SERIES() Breaks Minimal Logging
Eric M Russell wrote:
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, 11 months ago by Jeff Moden.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
September 19, 2023 at 8:11 pm

#4289832
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Jeff Moden wrote:
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...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 19, 2023 at 8:02 pm

#4289829
Reply To: Get data from wmic/winmgmt/etc

Phil Parkin wrote:
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.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 18, 2023 at 6:31 pm

#4289028
Reply To: GENERATE_SERIES() Breaks Minimal Logging

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

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 18, 2023 at 4:48 pm

#4288961
Reply To: Servicing SQL Server

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

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 18, 2023 at 3:07 am

#4288536
Reply To: Subscriptions Failing. Log contains "Error while copying content to a stream"

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.

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2023 at 4:41 pm

#4288327
Reply To: Servicing SQL Server

Rod at work wrote:

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

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2023 at 4:34 pm

#4288326
Reply To: Error while trying to shrink a data file

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

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2023 at 5:13 am

#4288092
Reply To: Get data from wmic/winmgmt/etc

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

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 17, 2023 at 5:03 am

#4288091

Reply To: Banker''s rounding in T-SQL (like Math.Round in .NET)

MarkCranness wrote:

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:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2023 at 9:36 pm

#4287958

Reply To: Data file shrink taking long time

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 Moden

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 16, 2023 at 9:29 pm

#4287951

Reply To: Servicing SQL Server

Lisa Slater Nicholls wrote:

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

--Jeff Moden