Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,836 through 8,850 (of 59,091 total)

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
Reply To: Are the posted questions getting worse?

Heh... more "new site" sucking sounds. The fnTally script that was recently published and nearly 4,000 reads and 9 votes yesterday. Today, it says it's only had a little over...
--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 4:27 pm

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

Heh... having this posted as a script has already started to pay off for me not only in a couple of posts on this forum but also on the "Azure...
--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 4:21 pm

#3671093
Reply To: Basics to loading data

David Burrows wrote:
Jeff Moden wrote:
Phil Parkin wrote:
below86 wrote:
IMHO, you are on the right path. I'm currently doing exactly what you described. Importing flat, delimited files to a 'staging' table where all fields are...
--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 2:39 pm

#3671047
Reply To: Moving a Table

tsalha wrote:
it is especially useful, if you need a table to be online all the time, but want to load lots of data to it (e.g. full reload). Then 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)

August 13, 2019 at 2:36 pm

#3671046
Reply To: Modern Datatime Addition

Post deleted... misread a response.
--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 2:25 pm

#3671034
Reply To: Backup size is doubled now. Want to know the reason why ??

prettsons wrote:
You can also try an appropriate option to control database size.
So long as it's not "AutoShrink", DBCC SHRINKDB, or DBCC SHRINKFILE (especially since they don't affect backup size).
--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 2:20 pm

#3671032

Viewing 15 posts - 8,836 through 8,850 (of 59,091 total)