Jeff Moden

Forum Replies Created

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

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
Reply To: How to add background color of row based to existing SP/query

SQLisAwe5oMe wrote:
Attached the script in .docx type.
You've been around for a long time and I think I've shown you this before but one more time.
When you're filling out a post...
--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:28 pm

#4016911
Reply To: What queries to tune first?

To add to what Johan posted, your worst performing queries will NOT usually be your longest running queries and it may not be the queries themselves, at all... it could...
--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 5:04 pm

#4016830
Reply To: Removing Text From All Rows

Like a lot of the other answers on this thread, that's a lot of non-bullet-proof IF's that will eventually result in silent errors producing an incorrect answer.
Don't assume. Yeah... 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 15, 2022 at 4:45 pm

#4016823
Reply To: Script SQLCMD to create DB with a variable: How to set it up?

My question would be...
Why are you storing such a script on the root of the C: where some users could tamper with it or delete it? This should be 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)

April 15, 2022 at 4:41 pm

#4016822
Reply To: Backup more that doubles in size

erouse wrote:
I have a SQL 2012 database with simple recovery that backs up every night. Normally the backup file is around 87,000 MB and grows proportionality as data is added. ...
--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 4:33 pm

#4016821
Reply To: SQL Query - Finding CPU age (how old)

@sets4life
Are you still there? If so, see my previous post.
--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 4:30 pm

#4016820
Reply To: SQL Query - Finding CPU age (how old)

sets4life wrote:
Hi All
Trying to do a query to find out how old are the cpu on device. We do have a way of doing it but it involves manual step...
--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 3:39 am

#4016512
Reply To: SQL Query - Finding CPU age (how old)

ScottPletcher wrote:
Didn't you already ask this q?!
According to the OPs profile, no. In fact, this appears to be the first and only question they've posted.

--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 3:14 am

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

Phil Parkin wrote:
When I do things like this, I return separate columns for the properties I wish to control (font, bold, colour etc) and then assign those columns to the relevant...
--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 3:04 am

#4016505
Reply To: How to handle multiple Aliases
One possibility for those is a bit shorter...
```
NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Req Created]
NULLIF(A.CALC_Date_EOIReceived,'1900-01-01 00:00:00.000') AS [Date Initiated]
```
If we could see the rest of the code, we could...
--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 14, 2022 at 4:41 am

#4015455
Reply To:

wrote:
I'm looking at a career change. I have bachelors degree in healthcare management and pre counseling. My mental health is going down the drain and do not think 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 14, 2022 at 4:28 am

#4015450

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