Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,646 through 9,660 (of 59,091 total)

RE: Varchar(Max) storage

Shirting gears a bit... very few people realize the change they made way back in 2005 concerning LOBs...
Prior to 2005, the default was to store LOB data "out...
--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)

March 18, 2019 at 10:22 am

#2024787
RE: Delete duplicate rows from ANY table.

That's cool. Clever idea on both parts.
The one thing that's still missing is the suggestion that someone needs to create PKs or AKs on the tables that had...
--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)

March 18, 2019 at 10:13 am

#2024786
RE: Subqueries examples

usererror - Monday, March 18, 2019 7:25 AM
This request also sounds odd to me. I'm also a newbie and I don't even...
--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)

March 18, 2019 at 10:09 am

#2024783
RE: Varchar(Max) storage

Eirikur Eiriksson - Monday, March 18, 2019 8:20 AM
Arsh - Monday, March 18, 2019 7:54 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)

March 18, 2019 at 8:38 am

#2024766
RE: PatExclude8K

I never actually trust the % of Batch stuff to make actual decisions about performance. I've also never seen a performance test on the use of the TEXT() function v.s....
--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)

March 17, 2019 at 5:18 pm

#2024740
RE: DBA Job interview question thoughts

jonathan.crawford - Friday, March 15, 2019 7:40 AM
Jeff Moden - Thursday, March 14, 2019 10:18 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)

March 17, 2019 at 5:03 pm

#2024738
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, March 15, 2019 10:47 AM
We're going to open up our qa site for more testing...
--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)

March 17, 2019 at 4:59 pm

#2024737
RE: Freeze Panes in Reports

sgmunson - Friday, March 15, 2019 11:33 AM
I know this is 10 years old, but a quick update is in order. 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)

March 17, 2019 at 4:57 pm

#2024736
RE: SP set "With Encryption" issues

My recommendation is to stop using "WITH ENCRYPTION". It does virtually nothing to protect your code. Even software packages like RedGate SQL Compare automatically breaks the encryption so the user...
--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)

March 17, 2019 at 12:42 pm

#2024729
RE: trimming SSNs

jonas.gunnarsson 52434 - Sunday, March 17, 2019 10:50 AM
Jeff Moden - Saturday, March 16, 2019 2:22 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)

March 17, 2019 at 11:38 am

#2024725
RE: How Long is Too Long?

Rod at work - Sunday, March 17, 2019 10:02 AM
Eric M Russell - Friday, March 15, 2019...
--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)

March 17, 2019 at 11:29 am

#2024724
RE: Recreating sane index not improve the performance

jkramprakash - Sunday, March 17, 2019 4:38 AM
yes.i checked the actual execution plan,it is not showing the particular index in the plan...
--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)

March 17, 2019 at 10:54 am

#2024723
RE: Sql Query to find invalid SSN Numbers

jcelko212 32090 - Friday, March 15, 2019 11:46 AM
It is also illegal to murder people. How has that worked form 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)

March 16, 2019 at 2:58 pm

#2024709
RE: Netezza Query takes forever and eventually times out, can this be re-written to run quicker?

cubangt - Friday, March 15, 2019 8:45 AM
SELECT
SS.ITEM,SS.SHIPMENT, MAX(SS.PROCESS_DATE) PROCESS_DATE
FROM SHIPMINTS SS
where...
--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)

March 16, 2019 at 2:54 pm

#2024708
RE: trimming SSNs

jonas.gunnarsson 52434 - Saturday, March 16, 2019 12:12 PM
All SSN handling/validation should be done in code, before sent to the database. 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)

March 16, 2019 at 2:22 pm

#2024706

Viewing 15 posts - 9,646 through 9,660 (of 59,091 total)