Jeff Moden

Forum Replies Created

Viewing 15 posts - 29,941 through 29,955 (of 59,101 total)

RE: Case in Where Clause? Alternatives pls.

RBarryYoung (5/17/2012)
!!! How did you guys get in front of me?!?
DBCC TIMEWARP 😀
--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)

May 17, 2012 at 3:13 pm

#1489385
RE: Case in Where Clause? Alternatives pls.

Lynn Pettis (5/17/2012)
CptCrusty1 (5/17/2012)
OK.. Case statement works, but is it the best way....
.....
AND (CASE WHEN COL_1 = 25 AND COL_2 <> 30 THEN 1
...
--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)

May 17, 2012 at 3:12 pm

#1489384
RE: Generating n-Tuples with SQL

SQL Kiwi (5/17/2012)
Jeff Moden (5/17/2012)
Heh... I have the proof. I just haven't posted it. Time for someone else to prove it besides me. 🙂
Well that doesn't really help...
--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)

May 17, 2012 at 2:34 pm

#1489364
RE: Database Tuning Advisor not giving recommendations for large query

Elizabeth.Block (5/16/2012)
The indexes weren't fragmented but they weren't good either.
Can you be more specific about that please? For example, how do you know they weren't good if they weren't...
--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)

May 17, 2012 at 11:42 am

#1489261
RE: Generating n-Tuples with SQL

SQL Kiwi (5/17/2012)
Jeff Moden (5/17/2012)
Shifting gears, just changing it to a While Loop using the exact same logic will make it more efficient.
It's not like you to make such a...
--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)

May 17, 2012 at 11:26 am

#1489248
RE: parse string

RBarryYoung (5/17/2012)
Though that description does raise some disturbing genetic questions ... 😀
BWAAA-HAAAA!!!!... dunno 'bout all that... have you taken a good look at your most recent avator? 😛
--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)

May 17, 2012 at 11:24 am

#1489245
RE: Generating n-Tuples with SQL

dwain.c (5/17/2012)
I get it! Change RBAR in your avatar to Dwain.C and there you have it.
Heh... considering the tagline in your signature, I do have to question why you...
--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)

May 17, 2012 at 7:46 am

#1489018
RE: Generating n-Tuples with SQL

dwain.c (5/17/2012)
Seriously, I'm smiling (:-D) because I figure that if I can stir up the emotions of the staunchly rigid and proper SQL aristocracy then I've done my job.
ABSOLUTELY...
--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)

May 17, 2012 at 7:38 am

#1489010
RE: Generating n-Tuples with SQL

SQL Kiwi (5/17/2012)
It still seems that your issues are more with the author (and Craig Freedman) rather than me.
Correct. I didn't mean to make it sound like I was...
--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)

May 17, 2012 at 7:08 am

#1488984
RE: Where are the good Senior Level DBA's?

Elliott Whitlow (5/15/2012)
Jeff,
You gotta give 'em cred for calling back that takes some stones.
CEWII
Heh... gotta give me some credit, as well. It took some stones of my own...
--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)

May 17, 2012 at 6:43 am

#1488961
RE: Generating n-Tuples with SQL

Sorry... the way my comment relates to the articles you cited and to Dwaine's article is that, while recursion is a mathematically sound way of expressing a problem, none of...
--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)

May 17, 2012 at 6:28 am

#1488949
RE: Generating n-Tuples with SQL

SQL Kiwi (5/16/2012)
Craig Freedman has a couple of great posts covering how recursive CTEs work:
http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
I do wish folks would do a comparison against the equivalent While Loops to see just...
--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)

May 17, 2012 at 5:29 am

#1488917
RE: Query Cost 27%

No problem. Thanks.
I ran the test you included in the Blog entry and actually did get seeks at the .5% and .3% levels instead of scans, but that still...
--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)

May 17, 2012 at 5:09 am

#1488911
RE: Query Cost 27%

GilaMonster (5/17/2012)
Jeff Moden (5/16/2012)
Are you suggesting that if I use something like a tenth of a table that a scan is virtually guaranteed?
If you are using a non-covering index, then...
--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)

May 17, 2012 at 4:45 am

#1488901
RE: Query Cost 27%

Thanks, folks... I'll take a deeper look.
--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)

May 17, 2012 at 4:26 am

#1488890

Viewing 15 posts - 29,941 through 29,955 (of 59,101 total)