Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,341 through 5,355 (of 59,072 total)

Reply To: Pivot table for report
Let's do what Steve did (and nicely explained/demonstrated) but on steroids.
First, we need a very typical million rows to test against...
```
--===== Create the test 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)
April 25, 2021 at 2:57 am

#3875426
Reply To: Pivot table for report

Steve Collins wrote:
Oops (again). Thank you Jeff. I updated the answer with before/after 2017.
Heh... thanks for the feedback, Steve. The reason I'm so very familiar with this one is that...
--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 24, 2021 at 11:04 pm

#3875378
Reply To: Deadlocks during concurrent delete operation

llearnsql wrote:
But my question is do we have a better approach to avoid deadlocks?
You bet there is. But, we can't help because we don't know what criteria you're using...
--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 24, 2021 at 10:59 pm

#3875373
Reply To: Looking Forward to SQL Server vNext

From the Article:
"The startup flags (1117 and 1118) recommended for tempdb are no longer needed as that functionality is now baked in."
Yeah... that little "trick" of theirs killed some...
--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 24, 2021 at 10:45 pm

#3875370
Reply To: xp_logininfo gives error while trying to fetch group info

If you look at the original 5 year old post on this thread, the OP didn't include the actual command they used. It could have been a spelling error 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 24, 2021 at 10:03 pm

#3875364
Reply To: Pivot table for report

Steve Collins wrote:
Yes, no STRING_AGG in 2012. We're in the 2016 Forum 🙂 To revert you could use STUFF+XML instead of STRING_AGG.
Doesn't matter if it is a 2016 forum... I'm...
--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 24, 2021 at 9:49 pm

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

You can ab
ratbak wrote:
I considered submitting a request asking for a way to suppress the dark mode request.
I actually have to use DATEDIFF_BIG. The fact they couldn't be bothered...
--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 22, 2021 at 7:57 pm

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

The Postgres function is the one that I remember the best. I've not tested it for performance because I've never had to work on a Postgres DB. Oddly enough, 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 22, 2021 at 2:56 pm

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

Jason A. Long wrote:
Ken McKelvey wrote:
You might be interested in an interesting series of articles by Itzik Ben-Gan:
https://sqlperformance.com/2021/04/t-sql-queries/number-series-solutions-4
Ken, Thank you for posting this link.
I was involved in that series 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 22, 2021 at 2:28 pm

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

ratbak wrote:
Note that Microsoft is preparing to switch, yet again, to a different feedback system.
Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021...
--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 22, 2021 at 2:03 pm

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

Carlo Romagnano wrote:
I use this function with recursion and @top of 1000000 is enough for me, but I don't n know if it performs better:
-- by Carlo.Romagnano CREATE FUNCTION dbo.fn_tally(@top...
--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 22, 2021 at 1:44 pm

#3874357
Reply To: Comparing Execution Plans

Personally, I like the 5th option, which wasn't included... Run the two versions of the same query in the same window and compare the execution plans that show.
--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 22, 2021 at 2:40 am

#3874154
Reply To: Index Maintenance

I know this is an old post but I just ran across it again while looking for something else. Probably doesn't make any difference to anyone anymore but...
Going through it...
--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 21, 2021 at 11:11 pm

#3874106
Reply To: sequence of SQL server execution plan

Heh... I agree with Grant on logical execution being left to right and data flow being right to left and both being top to bottom (except on super-umbra-red moons 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)

April 21, 2021 at 2:34 pm

#3873969
Reply To: Backup failed

Grant Fritchey wrote:
Yep. Without the rest of the error message, I can't even hazard a guess. Jeff is probably right (says Grant all the time).
Thanks, Grant. I'm humbled but I'm...
--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 21, 2021 at 2:21 pm

#3873956

Viewing 15 posts - 5,341 through 5,355 (of 59,072 total)