Jeff Moden

Forum Replies Created

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

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
RE: This really grinds my gears

I "love" the ones that remind me of many of the posts on these very forums... you know the ones... they send you a spreadsheet with a note "This doesn'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)

June 12, 2018 at 12:45 pm

#1993757
RE: Bizarre duplicate query plan

debasis.yours - Tuesday, June 12, 2018 9:08 AM
Hi,
I encountered this kind of issues due to mismatch between the SET properties 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 12, 2018 at 12:35 pm

#1993756
RE: Join on a substring value

If this is needed on a regular basis, I recommend a persisted computed column that can be indexed.
--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 12:30 pm

#1993755
RE: The SQL Joke Thread

Chris Harshman - Tuesday, June 12, 2018 12:22 PM
Luis Cazares - Tuesday, June 12, 2018 12:11 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 12, 2018 at 12:29 pm

#1993754
RE: querying on view takes long

Grant Fritchey - Monday, June 11, 2018 5:50 AM
jccalmerin - Friday, June 8, 2018 1:54 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 12, 2018 at 11:07 am

#1993734
RE: Same query, two users, different performance

shahm10 - Monday, June 11, 2018 7:44 PM
Can you modify the query to use two part naming standard [SchemaName].[ObjectName] and see 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 12, 2018 at 11:04 am

#1993732
RE: Machine Learning in the Database

skeleton567 - Tuesday, June 12, 2018 7:58 AM
Jeff Moden - Tuesday, June 12, 2018 7:40 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 12, 2018 at 9:09 am

#1993708

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