Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 59,067 total)

Reply To: How to prevent -5 Blocking Session

Johan Bijnens wrote:
fyi: Negative Blocking Session Ids
That's the same link that the Op provided in the original post on this thread. 😀
--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)

April 20, 2022 at 1:47 pm

#4019281
Reply To: Fact Table Update (Design)

Ok... based on your last post above, especially the part where you say there's a "requirement to make multiple submissions at various milestones during the month", here's what I think. ...
--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)

April 20, 2022 at 1:13 am

#4018898
Reply To: SQL DB Email sending,HTML body formatting from two tables

Awesome. Thank you for the feedback and welcome aboard!
--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)

April 19, 2022 at 2:49 pm

#4018668
Reply To: How to add background color of row based to existing SP/query

I'll try to work on this tonight after work. Thanks for the example.
--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)

April 19, 2022 at 2:45 pm

#4018664
Reply To: Scalar function string replacement

Jason A. Long wrote:
If you're using SQL Server 2017 or later, the TRANSLATE() function would be a better option.
I missed this. Considering what they did to the FORMAT function for performance, have...
--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)

April 19, 2022 at 2:24 pm

#4018637
Reply To: SQL DB Email sending,HTML body formatting from two tables

gwalton1234 wrote:
Thanks for this! It fixed my problem too.
This looks like a prelude to spam. Which problem of your did it fix and which of the many entries fixed it?
--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)

April 19, 2022 at 5:00 am

#4018351
Reply To: How a batch can get how much CPU it used in SQL Server 2019

Ah... got it. Now I know why the concern over milliseconds. Thanks for the feedback.
One of the issues is, of course, not bumping up the CPU time with a utility...
--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)

April 19, 2022 at 4:56 am

#4018350
Reply To: Script system stored procedures in master?

Post deleted. This thread did end up showing up in "active" threads.

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

April 19, 2022 at 4:18 am

#4018349
Reply To: Scalar function string replacement

@steve-2 Collins,
I also mean to say, GREAT question!
--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)

April 19, 2022 at 4:13 am

#4018348
Reply To: Scalar function string replacement

Jason A. Long wrote:
It's a good solution as long as you recognize that you're creating an internal Cartesian product between rows in the table value constructor (tvc) and the rows in 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)

April 19, 2022 at 4:12 am

#4018347
Reply To: Script system stored procedures in master?

Just in case someone comes across this again, I have a nice little update for all'ya'all. 😀
Step 1 is to create this function in your master database. Details are, 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)

April 19, 2022 at 3:26 am

#4018329
Reply To: Scalar function string replacement

Mr. Brian Gale wrote:
This feels almost like an undocumented "feature" (similar to quirky updates)... I know I would be a bit hesitant in how I used this and would probably continue 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)

April 18, 2022 at 10:57 pm

#4018260
Reply To: How a batch can get how much CPU it used in SQL Server 2019

uncager wrote:
Hi Michael. Without going into my reason, I need to know the sum of CPU usage for ad-hoc batches of SQL statements I execute, on a per-database and per-time-window...
--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)

April 18, 2022 at 5:27 pm

#4018123
Reply To: Backup more that doubles in size

I'm almost out of "off the top of my head questions" but, just to be sure, are you taking DIF backups and mistakenly naming them BAK like your FULL backups...
--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)

April 16, 2022 at 7:33 pm

#4017338
Reply To: What queries to tune first?

Dammit. I know I typed up a long explanation this morning of what "WorkLoad" means and now it's gone. Maybe I forgot to hit SUBMIT or something. Whatever. 🙁 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)

April 16, 2022 at 7:22 pm

#4017337

Viewing 15 posts - 3,601 through 3,615 (of 59,067 total)