Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,436 through 6,450 (of 59,089 total)

Reply To: Complex Join

I'm not talking about ISNULL speeding anything up, Scott. I'm talking about the use of a Clustered Index slowing things down. I'll try to come up with an example other...
--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)

September 14, 2020 at 2:47 pm

#3788337
Reply To: Writing a software development Proposal.

Write a section that identifies the purpose/problem this will solve. (Problem Overview)
Write a section on how the spreadsheets, etc, will solve the problems. If you have additional advantages, such as...
--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)

September 14, 2020 at 4:00 am

#3788175
Reply To: How to write query for multiple rows into a single row for different columns

That should do it, Mr. Williams.
--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)

September 14, 2020 at 3:48 am

#3788174
Reply To: Can't delete auto created statistics on SQL Server 2019

kaluza wrote:
Hi,
my problem was, that I have been connected to the wrong datebase with mit script.
Thank you very much for your help.
Thanks for the feedback and pretty darned honest 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)

September 13, 2020 at 12:55 am

#3788115
Reply To: Automation is a Key Skill for the Modern DBA

Automating things has always been a key skill of good DBAs and, so far as I'm concerned, has absolutely nothing to do with "DevOps", which is becoming a more 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)

September 12, 2020 at 7:36 pm

#3788103
Reply To: Retrieving the total number of records in a SQL instance

tarr94 wrote:
Hi Jeff,
I was asked to pull this information because our cyber insurance company wants an approximation of the total number of rows across all SQL instances. I imagine 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)

September 12, 2020 at 12:51 am

#3788041
Reply To: Remote Work Benefits

amy.holzinger wrote:
My office let me bring home an additional monitor when they sent me home to work. Very helpful! However, after 9 weeks my home office chair was giving me...
--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)

September 12, 2020 at 12:03 am

#3788037
Reply To: Complex Join

ScottPletcher wrote:
And, if forced to work on that SQL statement, I'd still remove the use of ISNULL, no matter what the comments stated.
So like I asked before... what would 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)

September 10, 2020 at 9:44 pm

#3787753
Reply To: Select unique records between several tables

a_car11 wrote:
Hi, they are not, I have one table called master, the others are named like acc_ and some numbers and letters after that. All I am trying 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)

September 10, 2020 at 9:12 pm

#3787741
Reply To: How to write query for multiple rows into a single row for different columns

First, if you get into the habit of posting "readily consumable data", you'll stand a much better chance of getting a coded answer and getting it a lot quicker. Here'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)

September 10, 2020 at 8:52 pm

#3787735
Reply To: Complex Join

ScottPletcher wrote:
Jeff Moden wrote:
While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always...
--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)

September 10, 2020 at 8:13 pm

#3787722
Reply To: First Monday of the Month

David Jackson wrote:
@jeff - for some reason the post you quoted in your previous post isn't showing the quote. Your reply to me is though! When I view in Gmail 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)

September 10, 2020 at 8:05 pm

#3787721
Reply To: Complex Join

While I usually and strongly agree that ISNULL shouldn't be used on table columns in a Join, Where, or other column based criteria matching, "It Depends" is always a consideration...
--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)

September 10, 2020 at 7:40 pm

#3787708
Reply To: First Monday of the Month

David Jackson wrote:
@jeff - I didn't think I was using an incremental rCTE?
Sorry, it wasn't directed at you. It was a post I commented on when it first came out 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)

September 10, 2020 at 7:26 pm

#3787705
Reply To: Creating a unique Batch ID for Update
Steve Collins wrote:
As general issues go does this require ##temp to have global scope? Also, why make the variables varchar(max)? I got it to work like this
```
drop 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)
September 10, 2020 at 3:56 pm

#3787593

Viewing 15 posts - 6,436 through 6,450 (of 59,089 total)