Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 59,098 total)

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
Reply To: How a batch can get how much CPU it used in SQL Server 2019

On way is to use the following dynamic management view...
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views
The "best" way would be to sample the view for the current SPID (@@SPID) that will run the "batch" for 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 16, 2022 at 7:03 pm

#4017333
Reply To: How to add background color of row based to existing SP/query
To answer the question that I think you're asking, do something like this just before you combine @Body and @XML.
```
SET @xml = REPLACE(@XML,'<tr>','<tr style="background-color:Red; color:White; ">')
```
If 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)
April 16, 2022 at 6:40 pm

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

This is going to depend a whole lot on what you mean by a "batch". What do you mean by "batch" here?
--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 6:09 pm

#4017308
Reply To: CPU usage of database for time spans in SQL Server 2019

Please don't mistake my answer as being "snarky"... I'm trying to help you help yourself in the future. 🙂
When you have a question like this, you have to ask yourself...
--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 6:03 pm

#4017307
Reply To: Seeing messages in Errorlog

Unless you have a process that requires that successful backups be logged in the SQL Server Error Log, I'd turn those off. Here's just one article on how to do...
--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 5:30 pm

#4017287
Reply To: Fact Table Update (Design)

Niggles wrote:
Q
Well now... that's pretty rude. 😉 The question you deleted may have helped others.
--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 4:05 pm

#4017276
Reply To: SQL Server 2014 Standard

I'm starting to see this exact question a whole lot. I'm starting to think that it's a prelude to spam. 🙁
To the best of my knowledge, the product keys 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)

April 16, 2022 at 4:01 pm

#4017271
Reply To: Conditional Formatting with SSRS

Parker Smith wrote:
Excellent summary and examples - especially appreciated the animation showing how to navigate the interface!
As a practical note, I recommend not leaning too heavily on color to provide meaning...
--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 15, 2022 at 10:11 pm

#4016952
Reply To: What queries to tune first?

vsamantha35 wrote:
Thanks everyone for sharing your inputs.
Sometimes we are seeing below patterns
"Application runs a query every 10 mins without any good reason."
There is a MERGE statement which does some data...
--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 15, 2022 at 8:48 pm

#4016929

Viewing 15 posts - 3,646 through 3,660 (of 59,098 total)