Jeff Moden

Forum Replies Created

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

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
RE: Parmissions issue running agent and bulk insert from network location

Bulk Insert uses the privs on the remote system as whomever or whatever is running it. You need for the SQL Agent service login to be able to see 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 26, 2017 at 6:33 am

#1948146
RE: replacing hard coded value with column name fails the query

jcelko212 32090 - Sunday, June 25, 2017 2:59 PM
Identifiers, such as application_id, cannot be numerics because you do know math on them.
Please post...
--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 25, 2017 at 3:39 pm

#1948088
RE: Are the posted questions getting worse?

TomThomson - Friday, June 23, 2017 8:19 PM
Sean Lange - Wednesday, June 21, 2017 3:25 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 24, 2017 at 7:24 pm

#1948068
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Saturday, June 24, 2017 1:25 PM
I sent a note to the devs. There is supposed 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 24, 2017 at 6:41 pm

#1948065

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