Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,806 through 8,820 (of 59,067 total)

Reply To: Combining Lists

MilesC wrote:
lol, I'm not even going to try. I almost always miss the Python and R questions. lol
Heh... ditto that. My "correct" answer would be "Why are you doing 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)

August 14, 2019 at 4:20 pm

#3671370
Reply To: SQL-2016 Query Timeouts/Long execution

GonnaCatchIT wrote:
Hi Jonanthan,
No we cannot set it to SQL-2008 as a company standard
You need to read some of the articles at the Google link I posted. You don't need 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)

August 14, 2019 at 3:04 pm

#3671342
Reply To: Give Up on Natural Primary Keys

This reminds me of discussions on "NULLs".
--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 14, 2019 at 3:00 pm

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

Beatrix Kiddo wrote:
Thom A wrote:
Neil Burton wrote:
And they've changed their minds.
Can we do that with some other recent decisions now please..? ??
Yes please!
This forum is really quiet now. I know...
--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 14, 2019 at 2:58 pm

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

Jonathan AC Roberts wrote:
Some things are much better on the new site. The ability to paste in SQL code without it reformatting it is really good.
That has been a blessing. The ability...
--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 14, 2019 at 2:52 pm

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

ZZartin wrote:
Speaking of website issues, is the bug where you have to unsubscribe from email notifications to a topic every time you reply going to be fixed?
I personally don't consider...
--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 14, 2019 at 2:50 pm

#3671338
Reply To: SQL-2016 Query Timeouts/Long execution

Perhaps it's the following problem. It was for us.
https://www.google.com/search?q=trace+flag+cardinality+estimator
--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 14, 2019 at 2:55 am

#3671208
Reply To: Create a Tally Function (fnTally)

Jason A. Long wrote:
Jeff Moden wrote:
Jason A. Long wrote:
Jeff Moden wrote:
For anyone interested in MS building such a function into T-SQL, please see the following thread. It used to have 278 votes until MS moved 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 14, 2019 at 1:49 am

#3671200
Reply To: Create a Tally Function (fnTally)

Jason A. Long wrote:
Aaron N. Cutshall wrote:
I am also amazed at the volume of folks who overuse recursive CTEs. It almost seems that they go out of their way to use them!
They do go...
--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 14, 2019 at 1:48 am

#3671199
Reply To: The Sequel to SQL

Rudy Panigas wrote:
My thought is more like a question. Why can't more features and functionality be added to SQL language and stop creating more languages to learn? If not, let's all...
--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 14, 2019 at 12:37 am

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

Steve Jones - SSC Editor wrote:
Bugs are being fixed and things repaired. This is the first I've seen/heard of this. It's been filed.
Thanks, Steve.
--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 13, 2019 at 10:06 pm

#3671183
Reply To: Performance Improvement Tips

Wow. I guess I'd not worry about anything else until those backup issues were fixed.
Thanks for the list. Always interesting to what what sp_Blitz ferrets out.
--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 13, 2019 at 9:59 pm

#3671182
Reply To: Performance Improvement Tips

Reporting servers are just moving the problem. People will complain on the reporting servers unless you fix the primary performance issue... which almost always boils down to (borrowing some emphasis...
--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 13, 2019 at 8:31 pm

#3671161
Reply To: Create a Tally Function (fnTally)

Thanks fr posting your code, Aaron. Good to see someone else using the "Union All" trick to get the zero value (it's also what I use) but I still 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)

August 13, 2019 at 8:27 pm

#3671158
Reply To: Create a Tally Function (fnTally)

Jason A. Long wrote:
Jeff Moden wrote:
For anyone interested in MS building such a function into T-SQL, please see the following thread. It used to have 278 votes until MS moved the "Connect" system...
--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 13, 2019 at 8:18 pm

#3671156

Viewing 15 posts - 8,806 through 8,820 (of 59,067 total)