Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 59,087 total)

Reply To: Printing Strings Longer Than 8000 Characters

Agreed. I was only reading what you quoted and that was my comment about Dynamic SQL. I totally agree DDL should be in source control. Sometimes, though, source control 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)

October 28, 2021 at 10:40 pm

#3945737
Reply To: Printing Strings Longer Than 8000 Characters

That's true, Phil... but I don't keep the results of Dynamic SQL in source control. I don't keep the code that gets stored in cache that I interrogate with my...
--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)

October 28, 2021 at 3:45 pm

#3945595
Reply To: Importance of Community

Now I'm truly humbled and seriously appreciative. You've cited the very reason I wrote those... a different way of thinking. Thank you so much for the taking the time 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)

October 28, 2021 at 3:40 pm

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

Sorry, Brandie... I'd be of no help in either area. They decided a long time ago that our infrastructure team would take care of such things to help with 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)

October 28, 2021 at 3:19 pm

#3945575
Reply To: T-SQL help

ScottPletcher wrote:
You didn't say what the result should be if it is tied, for example, 2F and 2M? In that case, I went with 'FemaleMix', adjust that if you need...
--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)

October 28, 2021 at 2:08 am

#3945331
Reply To: Printing Strings Longer Than 8000 Characters
Ron,
The following does the trick for me when I need to do such a thing. Details are in the flower box.
```
Create   FUNCTION [dbo].[ShowLongString]
/**********************************************************************************************************************
 Purpose:
 Display...
```
--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)
October 28, 2021 at 2:03 am

#3945330
Reply To: Printing Strings Longer Than 8000 Characters

Michael L John wrote:
I'm with Phil. Why are you doing this?
I can't speak for Ron but sometimes it's necessary to see, for example, the full monty for dynamic SQL.
--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)

October 28, 2021 at 1:59 am

#3945329
Reply To: Importance of Community

@Y.B. Thanks for the awesome compliment on the articles but neither they nor I made you look like a rockstar. I'm seriously honored that you cited me and them but...
--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)

October 27, 2021 at 11:05 pm

#3945297
Reply To: How to remove duplicate value from the rows in sql

shasivashok wrote:
Hi Team,
I am retrieving files and file created date and file modified date from table based on the created date. All files are same file name. My output is...
--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)

October 26, 2021 at 8:39 pm

#3944761
Reply To: Index rebuild

First of all, if you've done a REBUILD on an index and you very quickly exceed 30% logical fragmentation, then you're ACTUALLY CREATING A PERFORMANCE ISSUE and it can be...
--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)

October 26, 2021 at 8:35 pm

#3944760
Reply To: Replace Numbers

ZZartin wrote:
Jeff Moden wrote:
While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀
Don't worry I'm sure it's just...
--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)

October 26, 2021 at 12:28 am

#3944335
Reply To: A DateRange Table Valued function

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Nice function, Jonathan. Well done!
Thank you Jeff, that's a great compliment coming from someone as experienced as you.
I just used the function to hammer out a solution 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)

October 26, 2021 at 12:02 am

#3944334
Reply To: TSQL: Create dynamic partition DataRange

Let's try something a wee bit different and let's use a really nice tool written exactly for this type of thing. The tool was written by Jonathan Roberts, is a...
--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)

October 26, 2021 at 12:01 am

#3944333
Reply To: Burning Out

Great article but, having been there and done that, be REALLY careful that you don't (as my Grandmother used to say) "Jump from fat to fire" (reference to a cast...
--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)

October 25, 2021 at 9:09 pm

#3944289
Reply To: Replace Numbers

While you guys are bantering, I hope it's your SSNs that the OP is going to obfuscate with this easily broken method. 😀
--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)

October 25, 2021 at 6:09 pm

#3944235

Viewing 15 posts - 4,441 through 4,455 (of 59,087 total)