Jeff Moden

Forum Replies Created

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

RE: Varchar(Max) storage

David Burrows - Tuesday, March 19, 2019 8:04 AM
Jeff Moden - Monday, March 18, 2019 10:22 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 19, 2019 at 8:34 am

#2024904
RE: Are the posted questions getting worse?

below86 - Tuesday, March 19, 2019 7:43 AM
Jeff Moden - Tuesday, March 19, 2019 7:25 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 19, 2019 at 7:52 am

#2024898
RE: Minimal Logging

ti 93734 - Monday, March 18, 2019 6:00 PM
Both databases are permanently in simple recovery model.
Ok. And your code looks absolutely correct...
--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 19, 2019 at 7:46 am

#2024896
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Eirikur Eiriksson - Tuesday, March 19, 2019 7:18 AM
Quick question, are there any multi-line entries or can one use the new line...
--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 19, 2019 at 7:26 am

#2024891
RE: Are the posted questions getting worse?

below86 - Monday, March 18, 2019 8:38 AM
Sean Lange - Monday, March 18, 2019 7:29 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 19, 2019 at 7:25 am

#2024890
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Eirikur Eiriksson - Tuesday, March 19, 2019 6:20 AM
Jefferson Elias - Tuesday, March 19, 2019 4:31...
--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 19, 2019 at 7:15 am

#2024888
RE: Minimal Logging

ti 93734 - Monday, March 18, 2019 12:09 PM
My case is INSERT INTO .. SELECT, where I am inserting into a 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)

March 18, 2019 at 5:29 pm

#2024855
RE: Today's Random Word!

DesNorton - Monday, March 18, 2019 2:20 PM
Ray K - Monday,...
--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 4:11 pm

#2024848
RE: How can I offload the compute of SUM operation ?

ChrisM@Work - Monday, March 18, 2019 9:16 AM
Gamleur84 - Monday, March 18, 2019 2:06 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 10:37 am

#2024793
RE: Dealing with Failure

I wonder what's going through the minds of the Engineers at Boeing on the 737 Max issue right now.
--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:33 am

#2024792
RE: Request for count and "volume" of transactions

agerard 65681 - Monday, March 18, 2019 10:10 AM
Is that what the "read" column on a sql profiler trace is showing? Appears...
--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:25 am

#2024788
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

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