Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,851 through 14,865 (of 59,101 total)

RE: Are the posted questions getting worse?

jonathan.crawford - Tuesday, June 27, 2017 9:01 AM
Jeff Moden - Monday, June 26, 2017 6:44 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 27, 2017 at 5:57 pm

#1948466
RE: SUBSTRING and CHARINDEX query.... please help.

Sergiy - Tuesday, June 27, 2017 4:49 PM
Jeff Moden - Saturday, June 24, 2017 9:51 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 27, 2017 at 5:54 pm

#1948465
RE: Unable to understand the Query Logic

autoexcrement - Tuesday, June 27, 2017 2:18 PM
I love you Jeff Moden.
Thanks, but nah... I got the problem definition wrong.
--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 27, 2017 at 5:51 pm

#1948463
RE: Unable to understand the Query Logic

J Livingston SQL - Tuesday, June 27, 2017 6:20 AM
I think that this is the origin of the question, along with...
--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 27, 2017 at 9:18 am

#1948406
RE: Unable to understand the Query Logic

P.S. If you think I got the problem definition incorrect, that's certainly a possibility. If you think that, then provide a different problem definition and we'll take a crack at...
--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 27, 2017 at 12:29 am

#1948301
RE: Unable to understand the Query Logic

Ok... first things first. Let's look at the original data provided. I added spaces between the DT groups for clarity.
dt visitor
---------- ----------
2011-06-01 A
2011-06-01 B
2011-06-01...
--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 27, 2017 at 12:05 am

#1948300
RE: Unable to understand the Query Logic

sgmunson - Monday, June 26, 2017 12:28 PM
Jeff,
Thanks for the test rig. Yes, the triangular join isn't pretty. I chose to take...
--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 26, 2017 at 7:56 pm

#1948296
RE: Are the posted questions getting worse?

Sean Lange - Monday, June 26, 2017 2:25 PM
Eric M Russell - Monday, June 26, 2017 1:53...
--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 26, 2017 at 6:47 pm

#1948295
RE: Are the posted questions getting worse?

Eric M Russell - Saturday, June 24, 2017 8:24 PM
So, did anyone else have a strangely intense dream recently about being, outside...
--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 26, 2017 at 6:44 pm

#1948294
RE: Are the posted questions getting worse?

Sergiy - Saturday, June 24, 2017 9:07 PM
Jeff, ok, not mellow.But really - are 2 cups of coffe enough for you to...
--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 26, 2017 at 6:41 pm

#1948293
RE: Are the posted questions getting worse?

jasona.work - Monday, June 26, 2017 12:25 PM
What does it say that when I see a response written to a topic by...
--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 26, 2017 at 6:35 pm

#1948292
RE: Very bad performance issue joining 3 tables

To add to what Luis stated, sometime the pre-aggregation must be done separately in a Temp Table. I've seen many a report that would cripple the server with 50GB log...
--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 26, 2017 at 11:33 am

#1948216
RE: Help needed in resolving dead lock

shamantha4 - Sunday, June 25, 2017 12:39 AM
Ed Wagner - Saturday, June 24, 2017 1:33 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 26, 2017 at 11:22 am

#1948215
RE: Parmissions issue running agent and bulk insert from network location

bswhipp - Monday, June 26, 2017 6:37 AM
Duh, I didn't even think of that. So I need to change the SQL Agent...
--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 26, 2017 at 11:02 am

#1948203
RE: SQL Instances are in gray looking

IIRC, those are the servers that you can not restart the services for with whatever your current privs are.
--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 26, 2017 at 6:38 am

#1948149

Viewing 15 posts - 14,851 through 14,865 (of 59,101 total)