Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,586 through 6,600 (of 59,091 total)

Reply To: smtp in store procedure

I'll start off by saying that, once you've eliminated the double spacing, the first 463 lines of code are all a part of the dbo.sp_send_dbmail stored procedure, which is 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)

August 20, 2020 at 1:13 am

#3781846
Reply To: Job that runs slow how to use more CPU

Getting back to the original question, the reason why it's not using so much CPU is because it seems to be IO bound (IMHO) due to the RBAR nature 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)

August 19, 2020 at 11:36 pm

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

Speaking of pork chop cannons... here's one that needs about a 9 course dinner. I'll never understand such requests.
https://www.sqlservercentral.com/forums/topic/cutting-out-the-middleman-dba-how-to-give-access-without-involving-dba
--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)

August 19, 2020 at 7:30 pm

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

Greg Edwards-268690 wrote:
Amazing!
Is there a guide for in flight cooking? Frozen, thawed, and properly cooked would be good to know.
The rules for in flight cooking are simple... Frozen only... it makes...
--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)

August 19, 2020 at 7:27 pm

#3781750
Reply To: Cutting out the middleman DBA: how to give access without involving DBA

Mysterio wrote:
I don't believe that these replies are accurate.
That's a part of the problem. It's not up to analysts to decide who gets access to company owned data. 😉 That's...
--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)

August 19, 2020 at 7:21 pm

#3781746
Reply To: Cutting out the middleman DBA: how to give access without involving DBA

Mysterio wrote:
My situation: we have a team of analysts who create reports from a couple of databases. Analysts have sufficient access to read reports and write to tables. They create...
--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)

August 19, 2020 at 6:10 pm

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

Greg Edwards-268690 wrote:
Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?
The news ignores...
--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)

August 19, 2020 at 5:34 pm

#3781716
Reply To: Getting columns for sys. tables

For system objects, you won't get the system columns for system objects using INFORMATION_SCHEMA or sys.columns. You need to use the following...
sys.all_objects
sys.all_columns
sys.types (to get the datatypes of the columns)
--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)

August 19, 2020 at 11:38 am

#3781556
Reply To: Create a user and restrict access to only one DB Object

The keyword you're looking for is GRANT. Yeah, someone could tell you how to do this in just a couple of seconds but I'll suggest that you read the documentation...
--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)

August 19, 2020 at 11:23 am

#3781554
Reply To: How to compare strings by letters in certain places

Jason A. Long wrote:
Jeff Moden wrote:
I've finally had a chance to look at all that more carefully and, man, that has a VERY interesting execution plan. With a pre-split table, I might be...
--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)

August 19, 2020 at 1:51 am

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

Jason A. Long wrote:
My 15 yo brain is saying "ass/butt being divided infinity"...
Like Ed said, you're closer than you think...
Rather than continuing to torture with trivia... the answer is...
"My ass is on...
--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)

August 18, 2020 at 10:19 pm

#3781444
Reply To: Fostering Creativity

Davis wrote:
From the article:
We usually suspend regular activities from 3pm on Thursday to 4pm on Friday, allowing individuals and small teams to concentrate their efforts on their FedEx Day projects....
--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)

August 18, 2020 at 4:44 pm

#3781332
Reply To: Fostering Creativity

"Fostering Creativity". I think that assigning a specific day or week can be motivating but...
What I'd rather see is a company that "Fosters Creativity" all the time. There are multiple...
--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)

August 18, 2020 at 4:36 pm

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

Ok... one final set of hints...
If something goes wrong, they call the DBA and that's 24/7/365.
They also blame the DBA and the database for everything until the DBA can prove...
--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)

August 18, 2020 at 4:06 pm

#3781319
Reply To: How to remove quote marks using SSIS and a little C#

Of course, even without the "CSV" file type available in BULK INSERT as of 2017, it's pretty simple to make a BCP format file that will handle all of 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)

August 18, 2020 at 2:30 pm

#3781290

Viewing 15 posts - 6,586 through 6,600 (of 59,091 total)