Jeff Moden

Forum Replies Created

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

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
RE: Be Prepared with Baselines

Heh... I wonder how many people actually know how bad their system currently is when they take that first baseline. I also wonder if they actually do anything about it...
--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 11, 2018 at 8:31 pm

#1993627
RE: Cross Apply not summing correctly

tshad - Monday, June 11, 2018 1:32 AM
I was able to use this in the actual select statement and it worked perfectly.
Thanks.
Like...
--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 11, 2018 at 8:26 pm

#1993626
RE: Career, Certification, MCSA?2012? 2016?

claudioporter - Friday, June 8, 2018 9:01 AM
I do plan to change job because I believe where I am currently haven't given...
--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 11, 2018 at 8:20 pm

#1993625
RE: Microsoft and GitHub

Steve Jones - SSC Editor - Monday, June 11, 2018 11:20 AM
I think some people are driven by fear. Some want things...
--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 11, 2018 at 8:02 pm

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

mw_sql_developer - Sunday, June 10, 2018 3:00 PM
To make a long story short, one of our tables that have rx data...
--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 11, 2018 at 7:35 pm

#1993622
RE: remove only number in the given string

Is there any guarantee that ALL of the numeric characters will ALWAYS be contiguous in EVERY string?
--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 11, 2018 at 7:31 pm

#1993621
RE: Get Index Fragmentation Cheaply

Great. Ya just gotta love some of the intrinsic functions. Thanks for the feedback.
--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 10, 2018 at 10:51 pm

#1993500

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