Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,121 through 12,135 (of 59,102 total)

RE: Fast ways to load data from SQL server to SQL server

I dunno... seems like a lot of people try to jump through unnecessary hoops to do such things. I've got a plain ol' linked server between two of my boxes...
--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 13, 2018 at 9:40 pm

#1993941
RE: Building Test Data

A couple of decades ago, long before the words "Test Driven Development" ever parted anyone's lips, we called such reliable and safe test data a "Gold Set". And, yes, if...
--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 13, 2018 at 9:26 pm

#1993940
RE: Are the posted questions getting worse?

Jeff Moden - Wednesday, June 13, 2018 7:59 PM
Michael L John - Wednesday, June 13, 2018 1:09...
--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 13, 2018 at 8:27 pm

#1993939
RE: Calculating Work Days

Heh... this is a very old article... I don't believe I even knew what an implicit conversion was back then. 😀
Anyway, thanks for the science, Eirikur. Being a...
--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 13, 2018 at 8:09 pm

#1993937
RE: Problem numeric value to text value when i export table to Excel with OLEDB

Joe Torre - Wednesday, June 13, 2018 1:12 PM
Check this topic
Not sure if you're talking to me on that message,...
--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 13, 2018 at 8:03 pm

#1993936
RE: Are the posted questions getting worse?

Michael L John - Wednesday, June 13, 2018 1:09 PM
jonathan.crawford - Wednesday, June 13, 2018 12:17 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)

June 13, 2018 at 7:59 pm

#1993935
RE: Dates provide as string YYYYMM: Is best practice for storing as date (adding 01 as day) or as varchar(6) then manipulate to do date math?

Jeffrey Williams 3188 - Wednesday, June 13, 2018 1:35 PM
Phil Parkin - Wednesday, June 13, 2018 12:16...
--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 13, 2018 at 3:25 pm

#1993920
RE: The Data Submarine

Heh... having served aboard submarines, I can tell you that you simply don't ever need to clean the hull. Just take 'er out into some deep water and put some...
--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 13, 2018 at 3:19 pm

#1993919
RE: SQL Import table need to split up data then send to another table

tom.wallis - Wednesday, June 13, 2018 4:09 AM
Jeff Moden - Tuesday, June 12, 2018 7:46 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)

June 13, 2018 at 8:07 am

#1993857
RE: SQL Import table need to split up data then send to another table

tom.wallis - Wednesday, June 13, 2018 4:09 AM
Jeff Moden - Tuesday, June 12, 2018 7:46 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)

June 13, 2018 at 7:49 am

#1993848
RE: Problem numeric value to text value when i export table to Excel with OLEDB

sgmunson - Wednesday, June 13, 2018 6:45 AM
s.dartis - Wednesday, June 13, 2018 6:41 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)

June 13, 2018 at 7:43 am

#1993847
RE: The SQL Saturday Thread

Crud... For anyone interested, I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. ...
--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 13, 2018 at 12:16 am

#1993801
RE: Are the posted questions getting worse?

Crud... I found a technical issue with my presentations on Indexes and the 10/30 method for defragging them. My test harness was much too narrow in scope. I thought GUIDs...
--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 13, 2018 at 12:13 am

#1993800
RE: Join on a substring value

ScottPletcher - Tuesday, June 12, 2018 1:06 PM
Or, better yet, just go back to properly using 1NF in the table and store...
--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 12, 2018 at 1:11 pm

#1993764
RE: Problem numeric value to text value when i export table to Excel with OLEDB

It's really a shame they got rid of sp_MakeWebTask. Man, that was a great tool.
--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 12, 2018 at 1:08 pm

#1993763

Viewing 15 posts - 12,121 through 12,135 (of 59,102 total)