Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 59,098 total)

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
Reply To: Partitioning and Indexes needed on huge table

The big thing for partitioning for me has nothing to do with queries. As Grant indicates, partitioning almost never improves performance. Even so called "partition elimination" is usually slower than...
--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 5:56 pm

#3944230
Reply To: Identify what causes tempdb to increase

Johan Bijnens wrote:
SQL2005 doesn't have XE!
Check your default trace file or run a trace to figure it out !
Ah... thanks, Johan. Shows how much I use EE.
The problem with 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)

October 25, 2021 at 12:23 pm

#3944043
Reply To: How to get YYYYMMDDHHMMSS

Thank you for the great feedback and the quote from BOL.
Now if we could get the OP to cough up the reason for wanting to do this task. 😀
--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 24, 2021 at 6:30 pm

#3943810
Reply To: How to get YYYYMMDDHHMMSS

Bruin wrote:
This is getting the data I need, but not the format.
select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')
10212021102437
I want YYYYMMDD before the time portion.
Thanks.
Just out of sheer curiosity, why do 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)

October 23, 2021 at 10:26 pm

#3943663

Viewing 15 posts - 4,456 through 4,470 (of 59,098 total)