Jeff Moden

Forum Replies Created

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

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

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