Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,741 through 1,755 (of 59,082 total)

Reply To: How to make sure for each ID there was no records exists with text

jcelko212 32090 wrote:
And this is why we want posters to always put the DDL for their tables where we can see them. After 30+ years of doing SQL and RDBMS, I...
--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)

March 14, 2023 at 4:32 am

#4160393
Reply To: How to make sure for each ID there was no records exists with text

jcelko212 32090 wrote:
I am assuming that the foobars have a key made of the foo_description in the foo_id.
SELECT foobar_id
FROM Foobars
WHERE foobar_description IN ( 'Apex', 'Bill', 'Sierra' )
GROUP BY foobar_id
HAVING COUNT (*)...
--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)

March 13, 2023 at 6:18 pm

#4160250
Reply To: Sql server data export to csv with 100,000 row filesize limit

FlyingSquid wrote:
I'm using sql statements to query data from multiple tables and exporting them into csv files, then importing that file somewhere else.
I have to ask "Why" here. What is...
--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)

March 12, 2023 at 7:41 am

#4159815
Reply To: Stored Procedure to Output CSV from Select Query

water490 wrote:
Jeff Moden wrote:
It doesn't close any "security hole". Only the people that can enable it can use it. Turning it off won't prevent that.
As to your "access denied" error, where...
--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)

March 12, 2023 at 7:32 am

#4159813
Reply To: Sources of Inspiration

mschluper wrote:
Meeting customers' needs. That's all I want.
Any technology push stinks. And resume building is detestable.
We are here to serve. If we can't relate our activities to a specific customer...
--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)

March 12, 2023 at 7:25 am

#4159806
Reply To: Sources of Inspiration

Homer Roderick wrote:
We all need to be inspired by Chat-GPT
It is a game changer and if you don't learn the game then you lose the game.
Heh.. Ok... So, you're satisfied with...
--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)

March 12, 2023 at 7:22 am

#4159805
Reply To: Index and Statistics Maintenance

That's probably ok but the sys schema needs "love" 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)

March 11, 2023 at 10:13 pm

#4159751
Reply To: Index and Statistics Maintenance

Jonathan AC Roberts wrote:
Can you share your script?
Attached. Again, I'm very aggressive in the code. If the RowModCtr > 0, then I rebuild the stats. You can certain modify that based on...
Attachments:
You must be logged in to view attached files.
--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)

March 11, 2023 at 7:10 am

#4159603
Reply To: update stats vs rebuilding indexes

Ugh! Shrinking. It does "index inversion", which is one form of fragmentation that really does hammer performance into the ground. That's why I use the "Swap'n'Drop" method on a 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)

March 11, 2023 at 6:40 am

#4159596
Reply To: Stored Procedure to Output CSV from Select Query

It doesn't close any "security hole". Only the people that can enable it can use it. Turning it off won't prevent that.
As to your "access denied" error, where is 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)

March 11, 2023 at 5:30 am

#4159562
Reply To: DWH'ing from scratch

Chris Harshman wrote:
As for certification, just remember that certification is neither necessary, nor sufficient, for someone to be proficient in their work.
+1000!
--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)

March 11, 2023 at 5:20 am

#4159561
Reply To: First Two Words

Jonathan AC Roberts wrote:
If their plan fails, they can always go back to tipping Dogecoin or peddling courses on how to get rich quick by buying cheap stuff on AliBaba and reselling...
--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)

March 11, 2023 at 5:15 am

#4159560
Reply To: Sources of Inspiration

Howdy, Grant...
A lot of people won't be able to figure out how to get to this good article to read it because it's missing the clickable title. The icon 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)

March 11, 2023 at 3:50 am

#4159549
Reply To: How to make sure for each ID there was no records exists with text

@jonathan-2... that will work if "any" of the 3 are present. I'm thinking the OP only wants to exclude if all 3 are present. But, please, let him explain that.
--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)

March 11, 2023 at 3:41 am

#4159548
Reply To: How to make sure for each ID there was no records exists with text

mcfarlandparkway wrote:
Based on Group BY ID, I need to verify for each ID we have row exists with Description Apex, SIERRA, BILL.
Do you mean ID's that contain any of those...
--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)

March 11, 2023 at 3:38 am

#4159546

Viewing 15 posts - 1,741 through 1,755 (of 59,082 total)

Jeff Moden

Forum Replies Created

Attachments: