Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,136 through 12,150 (of 59,102 total)

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
RE: MERGE vs UPDATE

I'm in the same camp as Steve. MERGE had some pretty bad reports in the beginning. It's supposedly much improved but the damage was already done and I've seen nothing...
--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:05 am

#1993705
RE: GROUP BY

santoshghogare2008 - Tuesday, June 12, 2018 3:26 AM
Hi All,
i won't following output.find attachment for same.
multiple row of columns.
please suggest.
regards
santosh
This is known...
--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 8:50 am

#1993697
RE: Query Help

seismicbeat - Tuesday, June 12, 2018 5:18 AM
Hi,
I was tasked to address the following requirement.
A table contains the weekly (last 12 weeks)...
--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 8:47 am

#1993696
RE: T-SQL help needed to eliminate duplicates from table

mw_sql_developer - Tuesday, June 12, 2018 8:13 AM
Lynn Pettis - Tuesday, June 12, 2018 8:02 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 8:30 am

#1993692
RE: Return All affected dbs in error

Super Cat - Tuesday, June 12, 2018 4:10 AM
Thanks, I have resolved. Had a coffee and something to eat and my brain...
--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 8:21 am

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

Assuming that the data is "regular" in that it will always have the same "fields" to be converted to columns available, this data should never have made it into a single...
--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 7:46 am

#1993681
RE: Machine Learning in the Database

You also have to ensure that the machine is learning what is actually necessary. I recently bought a new Chevy Silverado and the amount of SPAM I now get about...
--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 7:41 am

#1993678
RE: Anyway to compress results of SELECT statement to improve transfer speed over network?

A brute force method would be to BCP the results out in "Native" format and import it at the receiver. Numerically based columns such as INT, BIGINT, and DATETIME (etc,...
--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 7:36 am

#1993676

Viewing 15 posts - 12,136 through 12,150 (of 59,102 total)