Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 59,101 total)

Reply To: How to convert characters or number to underscore and after that concatenate it

This seems to be really destructive. Are you just trying to do "Data Masking"?
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15
If you really do want what you've stated, then it's real simple (using 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)

June 8, 2021 at 1:30 pm

#3893419
Reply To: HASHBYTES giving different resaults than yesterday

I don't know of any such change. I'm thinking that there would be a million person march on Redmond if there were. Have you checked the raw data to see...
--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)

June 8, 2021 at 1:03 pm

#3893399
Reply To: how to get the entire sql statement while sql statment is over 4000 characters

Considering that my last name contains only 5 letters and you couldn't even spell that right, I suspect a PICNIC problem on your part. The code runs nasty fast 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)

June 8, 2021 at 12:58 pm

#3893371
Reply To: Load folder full of csv files

Hang in there. I made some good progress (fully testing along the way) but I had another late work night and it's time for bed (01:49 AM). I'll work 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)

June 8, 2021 at 5:50 am

#3893246
Reply To: SQL Injection using Varchar(15) - sending in much longer than 15 characters???

We're just guessing here... post the actual code for get_OrderVerified
--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)

June 7, 2021 at 5:19 pm

#3893059
Reply To: Help with SUBSTRING CHARINDEX

DaveBriCam wrote:
I'm still getting the "Invalid length parameter passed to the LEFT or SUBSTRING function." error.
See the first link in my signature line below and provide the readily consumable format...
--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)

June 7, 2021 at 5:14 pm

#3893057
Reply To: Recursive query problem - find ALL related records for a given record

CanuckBuck wrote:
Perhaps this diagram will help illustrate the situation. In any of the given scenarios I need to find ALL related nodes given the ID of any node in 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)

June 7, 2021 at 5:10 pm

#3893056
Reply To: The Tech Blame Game

IMHO, the only thing that has changed in the "blame game" or even the "tech blame game" is that a whole lot more of it is seen by the public...
--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)

June 7, 2021 at 3:49 pm

#3893027
Reply To: Scaling Deployment

I wish that people would start writing articles on "Scaling QUALITY". Actually, a lot of folks need to start on the 101 version of 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)

June 7, 2021 at 3:46 pm

#3893026
Reply To: Tables are empty but catalog views show that they have rows

One more shot in the dark. I'm actually following a thread of something kind of similar on another thread.
Since the tables are supposed to be empty and rowless, try doing...
--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)

June 7, 2021 at 3:43 pm

#3893024
Reply To: Load folder full of csv files

Bruin wrote:
I was thinking on the table and I would like to make separate columns for Oven and Line..
Funny thing there... I figured that early on (part of "column normalization)...
--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)

June 7, 2021 at 3:29 pm

#3893018
Reply To: Load folder full of csv files
Ok... We need some details...
1. Since the file names do NOT have any temporal indications in the names, what do you want to do with a file to move 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)
June 6, 2021 at 1:15 pm

#3892606
Reply To: Tables are empty but catalog views show that they have rows

SQL Guy 1 wrote:
Ran it now. Did not help. Also tried DBCC checkdb. Did not help either. In an output message it displayed There are 0 rows in 0 pages for object...
--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)

June 6, 2021 at 12:49 pm

#3892596
Reply To: max recommended file sizes (MDF NDF)

My take is that I'd worry more about splitting tables in a logical fashion that would require no index or statistics maintenance on data that no longer changes.
You might also...
--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)

June 6, 2021 at 12:41 pm

#3892593
Reply To: The NoSQL Misdirections

Sergiy wrote:
In University, you pick up humanitarian subjects, if you're bad at Math.
Pretty much the same situation with NoSQL/SQL.
Right or wrong, I blew coffee out my nose on that one! ...
--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)

June 6, 2021 at 10:55 am

#3892574

Viewing 15 posts - 5,191 through 5,205 (of 59,101 total)