Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,851 through 5,865 (of 59,072 total)

Reply To: Create Unique combination as Key out of N columns

ScottPletcher wrote:
I still prefer my single int as a metakey method. 16 bytes is a lot of overhead for a linking key. I don't see an advantage to it. 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)

December 18, 2020 at 5:56 pm

#3822144
Reply To: Create Unique combination as Key out of N columns
ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
And what if one or more of the column values change?
Like I said in the comments in the 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)
December 18, 2020 at 4:29 pm

#3822108
Reply To: Create Unique combination as Key out of N columns
ScottPletcher wrote:
And what if one or more of the column values change?
Like I said in the comments in the code...
```
     -- You can...
```
--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)
December 18, 2020 at 2:10 am

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

It had a great run and built one heck of a community. The community isn't dead and neither is the spirit of sharing knowledge that it inspired. We're going 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)

December 18, 2020 at 12:26 am

#3821821
Reply To: Deleting folder on a drive

richardmgreen1 wrote:
@jeff - My understanding was that, once CmdShell was enabled, is was usable by anyone. Nice to know that's not the case.
Oh my... now I understand why you were...
--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)

December 17, 2020 at 11:46 pm

#3821810
Reply To: Convert YTD data to Monthly data

It's probably not a "table", Joe. It's probably something that only looks like a table used to hold the results of a reporting query from somewhere. Having VARCHAR(2) for both...
--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)

December 17, 2020 at 11:38 pm

#3821809
Reply To: Create Unique combination as Key out of N columns

Ok, KT... here you go. I made a million row table just for test purposes. Although the use of HASH(MD5) is no guarantee of avoiding collisions forever, the "PIPES" 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)

December 17, 2020 at 6:16 am

#3821482
Reply To: Convert YTD data to Monthly data
First, thank you for posting the readily consumable data that you did. It made it a pleasure to help.
The following code will do the trick...
```
 SELECT *...
```
- This reply was modified 5 years, 6 months ago by Jeff Moden. Reason: Added partitioning by year, which is a bit necessary for YTD to Monthly calculations. :D
--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)
December 17, 2020 at 1:03 am

#3821425
Reply To: MSSQL 2019 - SQL Server Agent - Jobs account

They do make it difficult to find. 😀
Please see the following link...
https://docs.microsoft.com/en-us/sql/ssms/agent/manage-job-steps?view=sql-server-ver15#transact-sql-job-steps
In that section of the article, you'll find the following (emphasis is mine)...
Transact-SQL job steps do not use...
--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)

December 16, 2020 at 11:46 pm

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

Michael L John wrote:
Luis Cazares wrote:
In case someone missed it. There seems to be a big problem with Solarwinds Orion products, which some of you might use.
https://cyber.dhs.gov/ed/21-01/
A related story
https://www.washingtonpost.com/technology/2020/12/15/solarwinds-russia-breach-stock-trades/
While it seems...
--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)

December 16, 2020 at 11:04 pm

#3821400
Reply To: Deleting folder on a drive

richardmgreen1 wrote:
I've seen a way of deleting the folders using cmdshell but I'm wary of enabling it because of the potential security issues.
Heh... it's not the security risk that people...
--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)

December 16, 2020 at 10:54 pm

#3821389
Reply To: Creating indexes on a very large table takes over 5 hours

@pamkagel ,
Based on a phone call I got earlier today, do you work in Michigan, U.S.A.? I ask because it basically the same question I was asked if I could...
--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)

December 16, 2020 at 10:36 pm

#3821388
Reply To: SQL removing characters

JasonGerding wrote:
I am using the below case statement
, CASE WHEN Attributes LIKE ',Size = %,' Then right(Attributes, len(Attributes) - charindex('Size ', Attributes)) ELSE '' END as Size
To get the below...
--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)

December 16, 2020 at 10:18 pm

#3821382
Reply To: Help getting last 2 entries from split string with variable number of splits

tom 69406 wrote:
Thanks everyone.
As I'm developing under a deadline, I went with the first answer. And I'm developing with limited data, and we are expecting no more than a few thousand...
--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)

December 16, 2020 at 5:33 am

#3820998
Reply To: Change reference

Grant Fritchey wrote:
The restore operation using WITH MOVE will allow you to rename the database and create new data files. However, the only thing that will change the code is changing...
--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)

December 16, 2020 at 5:25 am

#3820996

Viewing 15 posts - 5,851 through 5,865 (of 59,072 total)