Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,451 through 12,465 (of 59,102 total)

RE: Random Word Generation for Data Scrubbing

SQLBlimp - Tuesday, May 1, 2018 7:54 AM
Eirikur Eiriksson - Tuesday, May 1, 2018 7:52 AM
--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)

May 1, 2018 at 9:48 am

#1988803
RE: Number of Days between two Day Names

I'll be interesting as hell to see what happens during a "wrap around" when the start day is a Thursday and the end day is a Monday. And what of...
--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)

May 1, 2018 at 9:37 am

#1988800
RE: Random Word Generation for Data Scrubbing

Great job, John. Can you share the link for the dictionary download that you used? I ask because most word lists seem to be rather unabridged when it comes 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)

May 1, 2018 at 6:09 am

#1988749
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Tuesday, May 1, 2018 2:56 AM
ChrisM@Work - Monday, April 30, 2018 10:05 AM
--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)

May 1, 2018 at 5:39 am

#1988745
RE: Advanced Data Masking

WebTechie - Monday, April 30, 2018 12:22 PM
Good afternoon.
I was told that we need to obfuscate the pii data in our lower...
--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 30, 2018 at 9:08 pm

#1988719
RE: Change Data format

Jason A. Long - Monday, April 30, 2018 12:32 PM
Jeff Moden - Monday, April 30, 2018 11:54...
--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 30, 2018 at 6:58 pm

#1988718
RE: Updating a column with serial numbers

jcelko212 32090 - Monday, April 30, 2018 11:10 AM
So there's no such thing as a first row, second row, etc.
There...
--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 30, 2018 at 11:57 am

#1988679
RE: Change Data format

jcelko212 32090 - Monday, April 30, 2018 10:37 AM
Eirikur Eiriksson - Thursday, April 26, 2018 12:55 AM
--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 30, 2018 at 11:54 am

#1988677
RE: Group by month and year

jcelko212 32090 - Monday, April 30, 2018 10:46 AM
You don't seem to understand that dates are not kept in strings in 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)

April 30, 2018 at 11:43 am

#1988672
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Monday, April 30, 2018 1:27 AM
Jeff Moden - Sunday, April 29, 2018 1:06 PM
--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 30, 2018 at 8:25 am

#1988642
RE: Is Azure a good decision for a major production application deployment?

Arjun Sivadasan - Sunday, April 29, 2018 10:58 PM
Why no love Jeff? 🙂
Azure SQL Managed Instance, apparently, lets you "lift...
--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 30, 2018 at 12:40 am

#1988600
RE: Is Azure a good decision for a major production application deployment?

Eric M Russell - Wednesday, January 18, 2017 9:16 AM
Yes, SQL Azure's contained database model will take some getting used to, 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)

April 29, 2018 at 10:50 pm

#1988598
RE: Are the posted questions getting worse?

Man, you've just gotta "love" ORMs...
WHERE (UNICODE([t0].[ActivityStatusCode]) = @p0) AND (UNICODE([t0].[DeficiencyAutomationStatusCode]) = @p1)
I just can't...
--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 29, 2018 at 1:06 pm

#1988592
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Sunday, April 29, 2018 12:04 PM
Jeff Moden - Sunday, April 29, 2018 11:15 AM
--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 29, 2018 at 1:03 pm

#1988591
RE: Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

btio_3000 - Sunday, April 29, 2018 11:05 AM
Eirikur Eiriksson - Sunday, April 29, 2018 2:10 AM
--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 29, 2018 at 11:15 am

#1988589

Viewing 15 posts - 12,451 through 12,465 (of 59,102 total)