Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 59,089 total)

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
Reply To: Backup failed

Don't you have access to the rest of the failure message from the SQL Server Error Log?
If I had to guess from the truncated message above, I'd say you may...
--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 1:14 am

#3873756
Reply To: Transaction log and updates on large tables

x wrote:
what about fn_dblog?
I updated a table with the same value and after doing this there were two more rows returned by fn_dblog. each time I ran the (duplicate)...
--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 20, 2021 at 9:39 pm

#3873707
Reply To: Help with detecting and sending alerts for lengthy blocking

TangoVictor wrote:
Jeff Moden wrote:
You can actually setup an alert for blocking and then you can have that alert call a stored procedure to get some amplifying information, record that information...
--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 20, 2021 at 9:17 pm

#3873703
Reply To: Transaction log and updates on large tables

Heh... it's not my story. It's in the link you provided. Paul proved it with code. Can you prove it to be otherwise with code?
--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 20, 2021 at 6:54 pm

#3873634
Reply To: Help with detecting and sending alerts for lengthy blocking

TangoVictor wrote:
Not looking for a solution just some suggestions for methods that have worked well for others.
You can actually setup an alert for blocking and then you can have 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 20, 2021 at 5:34 pm

#3873603
Reply To: Profiler Trace

Personally, I'd check the SQL Server Error Logs for deadlock events.

--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 19, 2021 at 6:04 pm

#3873182
Reply To: Database going to Recovery, while accessible.

@JohnyRotten,
Wow. I've never actually heard of any third party (nor anyone else, for that matter) using auto-close on a database before. Thanks for taking the time to post what 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 19, 2021 at 12:08 pm

#3873008
Reply To: Things We Are Missing

I've been pretty happy... as some say... "Loving the lockdown". But, I have to agree with you Grant. Being around people does promote spontaneous discussion, which supports and enables 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)

April 19, 2021 at 12:04 pm

#3873007

Viewing 15 posts - 5,371 through 5,385 (of 59,089 total)