Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 59,067 total)

Reply To: DBCC CHECKDB and Backup Database

Ok.. I've checked the code you provided for both the DBCC CHECKDB and the Backups. There are some serious opportunities for improvement in both...
With regards to the code provided for...
--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)

February 12, 2023 at 8:21 pm

#4148764
Reply To: Trying to get results back from 12 month ago thru 18 months ago from todays date

And thank you for the kind feedback!
--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)

February 12, 2023 at 1:38 am

#4148580
Reply To: Trying to get results back from 12 month ago thru 18 months ago from todays date

Sorry... duplicate post deleted.
--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)

February 11, 2023 at 11:10 pm

#4148556
Reply To: Trying to get results back from 12 month ago thru 18 months ago from todays date

Welcome aboard!
Rather than me explaining the things in the code that I demo, here are some references that do a better job than I could do. Code specific to your...
--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)

February 11, 2023 at 11:03 pm

#4148555
Reply To: Split field to top 4

Freakin' awesome test post, Jonathan. Well done, good Sir!!! This also proves something else... code written to do a specific task is highly likely to blow generic methods out of...
--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)

February 11, 2023 at 6:00 pm

#4148504
Reply To: Split field to top 4

Jeffs1977 wrote:
I need to split the column 'DiagnosisCodes' into 4 new columns 'Diagnosis1', 'Diagnosis2', 'Diagnosis3' and 'Diagnosis4' for the unique ChartProcedureId's. If they add more DiagnosisCodes, I only need the...
--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)

February 11, 2023 at 5:54 pm

#4148503
Reply To: Split field to top 4

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
I think you can beat any splitting function by splitting in code with no need for aggregation.
As there are only a maximum of 4 values you can...
--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)

February 11, 2023 at 5:09 pm

#4148479
Reply To: DBCC CHECKDB and Backup Database

That's one of the reasons why I want to see both the Backup and DBCC commands that are being used. We don't know what the OP is actually using.
--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)

February 11, 2023 at 5:02 pm

#4148477
Reply To: Constant Learning

Heh... the previous post was SPAM about a "diet plan" that recommended ingesting cotton balls as part of the diet. I agree that's a bit ridiculous.
In that same vein, you...
--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)

February 11, 2023 at 4:52 pm

#4148473
Reply To: DBCC CHECKDB and Backup Database

To start with, please post one of the actual backup commands that gets executed. Obfuscate the name of the database and any machine names the command may contain but don't...
--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)

February 11, 2023 at 3:59 pm

#4148448
Reply To: Operating System Error on Bulk Insert

David Burrows wrote:
Jeff Moden wrote:
I wrote some T-SQL to read the first row (which contained the column names) and had it create a CREATE TABLE statement from that header and the BCP...
--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)

February 11, 2023 at 12:35 am

#4148296
Reply To: Split field to top 4

Jonathan AC Roberts wrote:
I think you can beat any splitting function by splitting in code with no need for aggregation.
As there are only a maximum of 4 values you can safely use...
--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)

February 10, 2023 at 9:41 pm

#4148266
Reply To: Operating System Error on Bulk Insert

That's a good start.
When I was hot and heavy into doing a shedload of them for a whole bunch of different files, I wrote some T-SQL to read the first...
--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)

February 10, 2023 at 9:36 pm

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

Steve Jones - SSC Editor wrote:
https://ayende.com/blog/198945-B/on-ai-gpt-and-the-future-of-developers
Same problem in that article that many have. The author ends it with a conclusion of "My final conclusion is that this is a really awesome tool to...
--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)

February 10, 2023 at 9:16 pm

#4148260
Reply To: Operating System Error on Bulk Insert

p.s. And I disagree... getting FORMAT files right isn't really a fright in my book.
--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)

February 10, 2023 at 8:07 pm

#4148230

Viewing 15 posts - 1,921 through 1,935 (of 59,067 total)