Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,431 through 23,445 (of 59,099 total)

RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

ColdCoffee (6/13/2014)
Now that we have new analytical functions, just wanted to jump in on the new windowed functions fun 🙂
; WITH CTE AS
(
SELECT P.CustomerID ,P.ProductCode
...
--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 13, 2014 at 4:48 pm

#1721674
RE: Removing joins & Execution Time

ramana3327 (6/13/2014)
Hi,
I do have a general question.
I have a query which contains 12 left outer join. I remove some of the joins that don't have parameters. The result is...
--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 13, 2014 at 4:45 pm

#1721672
RE: Shrink runs forever

Eric M Russell (6/13/2014)
shahgols (6/12/2014)
TheSQLGuru (6/6/2014)
Wow - all that for 30GB of space?!? Sad to be worried about so little in today's age! :w00t:
I had to fight the storage...
--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 13, 2014 at 11:15 am

#1721594
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Ed Wagner (6/13/2014)
As always, an excellent article, Jeff. Then again, we've come to expect nothing less.
Thanks, Ed. Better than the article, though, look at the great discussions going...
--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 13, 2014 at 11:10 am

#1721590
RE: Just curious, what are your SQL pet peeves ?

I really don't like integer dates. They're tough to do date math with and they have no built in checks for whether an entry is a legal date or...
--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 13, 2014 at 11:02 am

#1721585
RE: Are the posted questions getting worse?

Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last...
--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 13, 2014 at 10:53 am

#1721578
RE: Developers vs. DBAs

Sorry... another dupe removed.
--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 13, 2014 at 12:08 am

#1721322
RE: Developers vs. DBAs

Sorry... dupe removed.
--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 13, 2014 at 12:05 am

#1721321
RE: Developers vs. DBAs

thomashohner (6/12/2014)
My first response is that I'm neither I'm a noob... But seriously I'm a report writer where do we fall? Red headed stepchild???
Heh... report writers. They're the disdain...
--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, 2014 at 11:10 pm

#1721315
RE: Just curious, what are your SQL pet peeves ?

Heh... I got carried away on another post on the subject of "pet peeves". Thought I'd repost what I wrote there on this thread because it seems appropriate. ...
--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, 2014 at 7:17 pm

#1721296
RE: Surrounding proc definitions with BEGIN ... END

Ed Wagner (6/12/2014)
I use the BEGIN...END for procedures because that's how I learned many moons ago. Gail's right - it is consistent with functions. In fact, when writing...
--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, 2014 at 7:12 pm

#1721295
RE: Surrounding proc definitions with BEGIN ... END

tim.berry 88829 (6/12/2014)
Should really be a begin try with a subsequent error handling begin catch
tim.berry 88829 (6/12/2014)
Horses for error handling courses i.e. whether there is a try catch or not...
--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, 2014 at 5:46 pm

#1721285
RE: Just curious, what are your SQL pet peeves ?

andrew gothard (6/12/2014)
Jeff Moden (6/6/2014)
A recent post just reminded me of one of my greatest pet peeves... people ~~that~~ who correct your English, spelling, or punctuation on forum posts. ...
--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, 2014 at 2:29 pm

#1721244
RE: Would like some feedback on contractors as employers

Doctor Who 2 (6/12/2014)
Alan.B (6/11/2014)
I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market...
--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, 2014 at 2:23 pm

#1721242
RE: Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

simonc 39536 (6/6/2014)
I think a lot of people seem to focus purely on performance, a good solution to a given issue considers many factors, NOT just performance, people who focus...
--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, 2014 at 4:20 pm

#1720915

Viewing 15 posts - 23,431 through 23,445 (of 59,099 total)