Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 59,089 total)

Reply To: DBMail

I have no suggestions based on what you posted. Everything seems correct but your check in msdb.dbo.sysmail_allitems seems to say they didn't actually go but there are no errors anywhere...
--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 22, 2021 at 4:16 pm

#3922601
Reply To: Calendar report for SQL Agent Jobs - what GUI do you recommend?

I'm going to have to defer to someone else on that question for details. I stopped doing anything like that way back in 2003. I do remember that there was...
--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 22, 2021 at 4:41 am

#3922524
Reply To: Create a delta from downloaded info

I almost forgot. One "trick" I do (that I didn't do here) is to add an "_stg" suffix to the column names in the staging table so that when I'm...
--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 22, 2021 at 2:32 am

#3922509
Reply To: Create a delta from downloaded info

I used to use EXCEPT but usually don't anymore because an old friend showed me long ago just exactly how slow it can actually be and Andy Leonard confirmed 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)

August 22, 2021 at 2:20 am

#3922507
Reply To: Trying to understand parentheses placements

One great aid for me is built into SSMS itself. Let's first make sure that you're setup for it. The setup only needs to be done once.
Step 1: From 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)

August 22, 2021 at 12:25 am

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

Brandie Tarvin wrote:
Jeff Moden wrote:
Brandie Tarvin wrote:
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
It's late, so I might be missing something here. Are 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)

August 21, 2021 at 10:23 pm

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

J Livingston SQL wrote:
Brandie Tarvin wrote:
I am getting really annoyed with this "link to the post takes me to the second last page of the thread, not the actual post" issue.
yup .... and...
--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 21, 2021 at 10:11 pm

#3922474
Reply To: Generate Create Script for a table - include indexes, keys, statistics

Luis Cazares wrote:
Would a T-SQL option help? http://www.sqlservercentral.com/scripts/SQL+Server+2005/67515/
It's a bloody shame that the "upgrades" to the forum software have rendered such links totally useless. 🙁

--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 21, 2021 at 4:33 pm

#3922448
Reply To: Mysterious ability to drop / create stored procedures

frederico_fonseca wrote:
I assume you know which login dropped/created the procs.
and assuming you are a SYSADMIN what output do you get out of these
execute as login = 'loginname' SELECT * FROM...
--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 21, 2021 at 4:01 pm

#3922441
Reply To: Calendar report for SQL Agent Jobs - what GUI do you recommend?

You say you want it to be displayed "just like the calendar entries are shown on a regular calendar". If you have 500 to 1000 jobs on a server lie...
--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 21, 2021 at 3:53 pm

#3922440
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

First round of testing to 1, 2, 4, and 8 files on a single SSD drive of a minimally logged, single connection insert of 10,000,000 rows @89GB of a table...
--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 21, 2021 at 8:51 am

#3922369
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

Heh... an early look scared-up the ol' "not unless they're on different physical spindles" adage. While I logically agree with that, I've never actually tried it and so I 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)

August 21, 2021 at 5:36 am

#3922347
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

Getting back to the original question, we're just guessing based on related information supposed "Best Practice" information and, by now, I'm sure everyone knows how I feel about "Best Practice"...
--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 21, 2021 at 5:16 am

#3922338
Reply To: A Lack of Error Handling

Just like index maintenance and a couple of other things, it's better to NOT do something than it is to do it wrong and, thanks to the poor examples in...
--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 21, 2021 at 4:50 am

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

Brandie Tarvin wrote:
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
It's late, so I might be missing something here. Are you saying 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)

August 21, 2021 at 4:29 am

#3922334

Viewing 15 posts - 4,786 through 4,800 (of 59,089 total)